SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Is it possible that sql server makes the server s
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

asp__developer
Posting Yak Master

108 Posts

Posted - 06/20/2013 :  13:42:47  Show Profile  Reply with Quote
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 ?

Edited by - asp__developer on 06/20/2013 16:34:44

James K
Flowing Fount of Yak Knowledge

3744 Posts

Posted - 06/20/2013 :  14:46:45  Show Profile  Reply with Quote
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.

Edited by - James K on 06/20/2013 14:47:11
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000