Category: FAQ
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?
Our SQL Server is experiencing lots of blocking, but we don't have any resource bottlenecks.