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.
| 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. |
 |
|
|
|
|
|
Is it possible that sql server makes the server s