Microsoft Blog Images
Browse by Tags
Search this blog
Search all blogs
Email Blog Author
RSS for posts
RSS for comments
Tagged Content List
Cool... Now we have a calculator for finding out a Max. Server Memory value
This calculator is now withdrawn since I'm not able to invest my time to improve it to make it "stay current". Apologize for the inconvenience! Hello SQL Community, I have written a simplified “Max. Server Memory” calculator for calculating "Max. Server Memory" value for...
18 May 2012
Service Broker "Fire and Forget Scenario" and Memory Allocation failure
"Fire and Forget" is a scenario in Service Broker where Initiator starts a conversation -> Sends a message -> End Conversation without considering whether Target received and processed the message. In these scenarios, the Service Broker conversations get piled up which you can see by querying sys...
4 Apr 2011
Max. Worker Threads and when you should change it
This is a get started post for this topic and I will be adding more content as and when it is available Worker threads are the agents of SQL Server which are scheduled in CPU and they carry out the tasks Memory for Worker threads come from Non-Buffer Pool region of SQL Server. You can configure...
13 Mar 2011
Importance of setting Max Server Memory in SQL Server and How to Set it
Of late, I'm observing that some of the customers are not setting up Max. Server Memory Properly or they never set Max. Server Memory at all in 64-bit SQL Server installations. What will happen if I don't set Max. Server Memory? Working Set trimming, Operating System unresponsiveness, Performance...
11 Mar 2011
T-SQL Query Script to monitor Memory Usage of a SQL Server Instance
If you are using Task Manager to monitor the Memory Usage of SQL Server, please note that Working set shown in Task Manager for SQL Server does not include memory committed by SQL Server using AWE allocations and Large pages. Also "Total Server Memory" Performance Counter is also not the total memory...
28 Feb 2011
Query to find what modules are loaded inside SQL Server VAS (Virtual Address Space)
Code of sqlservr.exe and any other dll's it depends on need to be loaded into SQL Server memory space for execution. So if you are having VAS fragmentation, there are multiple causes and one of the cause is numerous dll's loaded by extended stored procedures. So to find what dll's are loaded and how...
23 Feb 2011
Page 1 of 1 (6 items)
© 2013 Microsoft Corporation.
Privacy & Cookies