Server Performance

[nowayout]

Hi all,

I have question? I have SQL server and the memory is more than a gig. but the performance is getting slower now when i go into task manager the SQLserv.exe process taking more than 800 MB so what could be the solution.

Thanks,,,

 

[sguslan]

Is it still slow when you restart SQL? If it is, then it is an application tuning problem or DB index issue. If it starts fast for a while then is slows down, then you have a memory leak or similar problem and you may have to patch SQL with the latest service pack.


________________________________________________________________________________
If you do not like change, get out of the IT business...

 

[tlbroadbent]

As I mentioned in nowayout's other thread (thread183-540270)regarding this question, SQL Server's use of 800 MB of memory doesn't indicate there is a memory leak or other problem. SQL Server just works that way. It utilizes as much memory as possible to achieve a high level of performance.

Unfortunately, most SQL Server performance problems are rooted in the application and database design. Likewise, unfortunately, developers always want to "round up the usual suspects" - the hardware, SQL Server, defects, or the OS before they will analyze their own code for optimization. I should know, I fall into that trap myself far too often.

Before you can determine what the problem is, you have to monitor the server and applications. Find out what is causing performance problems. Monitoring cannot be approached casually. You need to plan and determine what and how to monitor. See the other thread for some helpful links. See the FAQ area for some performance tips.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[sguslan]

I concur with you Terry. I list below some URLs for nowayout that shed light on the subject and on the use of SQL Profiler ....

http://www.sql-server-performance.com/sql_server_profiler_tips.asp

http://www.sql-server-performance.com/application_design.asp

http://www.sql-server-performance.com/query_analysis_tuning.asp

________________________________________________________________________________
If you do not like change, get out of the IT business...