September 15, 2010 at 10:53 pm
Hi All, my cpu reaching 100% if any 2 r 3 users running queries, my issue is I am going to move this server to live then this server will connect to 300 users, then how my cpu situation, can anyone suggest me how to solve this issue, my system is windows server 2008 and sql server 2008R2, 4 processors,8 Gb Ram.
September 15, 2010 at 11:50 pm
Hi
U can check Ur query against database by using DTA and refer the result to change in query if possible.
Ali
MCTS SQL Server2k8
September 16, 2010 at 1:52 am
Most likely the queries are bad.
Ensure that you have correct indexes, and that those indexes are being used.
Can you post a query ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply