November 19, 2009 at 9:19 am
Dear All,
I need a help, can anybody tell me how to increase db performance.
Please tell me the performance tuning parameters and their best values.
I have a MS SQL2000 Enterprise Edition with 4 GB RMS and there is only db that is 5 GM in the size but whenever I check in Task Manager where sqlservr.exe using the approx 1.6 GM RAM.
I can't understand why it using that much memory.
Please assist.
Regards,
Syed Kamran Faisal
November 19, 2009 at 9:51 am
SQL Server will grab up all of the memory available to it. The performance of the database platform relies heavily on using the memory buffers for caching data, execution plans, etc. So the fact that you see it taking up 1.6 GB does not mean that it is actively using that memory. It has just 'reserved' it for use. From task manager, this shows up as the sql server task using 1.6 GB. No big deal, that's how it is supposed to work.
Are you having performance issues with your DB?
November 20, 2009 at 3:08 pm
Yes, I am facing db performance issue that's way I want know that how I can tune the db.
I want know if there is any performance tuning parameters with their best value.
One more think I want to know that my db size (MDF) is 5 GM and its log (LDF) size is 3 GB, will db
performance be improved if we delete the log file and create new one?
Or will re-indexing be worked in increasing the db performance?
Or will single reboot be worked in the same because db server has been running for two months?
Regards,
Syed Kamran Faisal
Thank you all
November 20, 2009 at 4:02 pm
syedkamranfaisal (11/20/2009)
Yes, I am facing db performance issue that's way I want know that how I can tune the db.I want know if there is any performance tuning parameters with their best value.
One more think I want to know that my db size (MDF) is 5 GM and its log (LDF) size is 3 GB, will db
performance be improved if we delete the log file and create new one?
Or will re-indexing be worked in increasing the db performance?
Or will single reboot be worked in the same because db server has been running for two months?
Regards,
Syed Kamran Faisal
Thank you all
DON'T delete the log file. Log file and Data file should be properly sized to expected growth and usage of the data.
Performance counters - there is no set standard answer.
Here is an article to read. http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
and another article
And a podcast
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 20, 2009 at 4:04 pm
Oh, and one more podcast by Brent Ozar
http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 21, 2009 at 2:21 am
syedkamranfaisal (11/20/2009)
will db performance be improved if we delete the log file and create new one?
No, but you could very likely end up with a suspect and unusable database. The log is not an optional piece of the database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply