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 |
|
kshahzad
Starting Member
45 Posts |
 Posted - 2013-07-04 : 09:48:36
|
| 0 Hi we have this Medical application running, iam having performance complaints, Memory and CPU are below 30% i am not sure how to start looking and fixing as i am new in company. thanks |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-04 : 10:52:59
|
| This could be due to a number of reasons. I would start out by looking at how much memory the box has, and how much of it is being used by SQL Server. Are there other applications running on the same box? What are the queries being run?For seeing how SQL Server uses the memory and how you should control it, see this article, in particular, the section How to configure memory options using SQL Server Management Studio. http://msdn.microsoft.com/en-us/library/ms178067.aspx You should configure it such that you leave enough memory for all other applications that may be running on that computer. If it is dedicated to SQL Server, leave at least 2Gigs for Windows OS.If that all seems ok, then look at the queries that are consuming the resources. Google for queries that give you this information. Here is one: http://blog.sqlauthority.com/2010/05/14/sql-server-find-most-expensive-queries-using-dmv/ |
 |
|
|
|
|
|
SQL Performance