March 16, 2009 at 6:26 am
Hi
In windows task manager under process
if i chek sqlservr.exe is taking 1.2 GB of memory. Every time I have to stop the sqlserver and start to increase the performance of my machine
Can any body explain what to do to increase the performence of sqlserver
Thanks in advance
March 16, 2009 at 8:12 am
That's a huge topic. First, you need to figure out what is causing the performance to slow down. Since, at this point, you're completely in the dark, I'd suggest taking a look at this document from Microsoft. It focuses on using the waits and queues to determine where things are slowing down. Once you know what's causing the slow down, then you can start working on fixing it. With no knowledge of what's causing the slow down, any advice now, while well intended, might not help at all.
You might want to look at picking up a book or two and looking through the books online to start getting a handle on what you should be monitoring & looking at.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 16, 2009 at 9:22 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic676411-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply