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 64-bit SQL Server instances after seeing my blog referenced in MSDN forums,…

4

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.conversation_endpoints. When you run the query below on the…

1

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…

3

Importance of setting Max Server Memory in SQL Server and How to Set it

UPDATE: This blog is applicable for SQL Server versions till SQL 2008 R2. Memory Manager has changed in SQL 2012 and above 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…

11

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 used by SQL…

32

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 much…

0