Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Is it possible that sql server makes the server s

Author  Topic 

asp__developer
Posting Yak Master

108 Posts

Posted - 2013-06-20 : 13:42:47
My server has a sql server 2008 installed on it and a software is using sql server on daily basis. The sql server service is taking all the resources and making the server slow ?

Is it sql server issue ? application problem ? or server hardware needs boost ?

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-06-20 : 14:46:45
What resources is it taking up? You can look in task manager or perfmon to get an idea.

One thing that SQL Server routinely does is take up all the memory it is allowed to regardless of whether that will result in other applications and the OS starving for memory. To avoid that you should limit the amount of memory that SQL Server is allowed to take. You can set that up by right-clicking on the Server Name in SSMS object explorer, selecting properties, and then the memory tab. In the memory tab, set the Maximum Server Memory (in MB). A rule of thumb for a server which has no other applications running on it is to leave at least 2GB of memory. So on if you had 32GB of memory, you would set the MAX memory at 30000 MB or so. The number you specify on that screen is in MEGABYTES, not Gigabytes.
Go to Top of Page
   

- Advertisement -