Category: Performance Tuning
We have recently added a second processor to our SQL Server box. How can I configure it to take advantage of the new processor?
Why isn't my SQL Server taking full advantage of all the RAM I have available in my server?
Is there a practical limit to the size of a table I can pin into memory?
Is there any benefit for me in turning on the "lightweight pooling" SQL Server configuration option?
Is it better to have one large server running multiple databases, or several smaller servers running one database each?
Is there any way to allocate processor utilization to SQL Server jobs?
Can you tell me more about the processor queue length?
Is it recommended to install SQL Server on a Windows domain controller?
We have a growing population of Access users. My question is whether there is a way of lowering these user's priorities on our SQL Server?