November 20, 2010 at 8:53 am
Hi ,
I've sort of inherited a mess at a company where SQL Server 2005 is used for the data store of an ERP System. Built on top of it all is an ASP.net web application. Users complain of the site being slow.
I want to start from the ground up and make sure the SQL Server is not the problem. Can someone provide a checklist for me to follow?
If you need any more info, let me know.
Some specs:
DB size = 18 GB
1 Windows Server 2003 R2 x64 SP2 @2.83Ghz, 15.9 GB Ram
Thnx!
November 20, 2010 at 10:27 am
This article explains it nicely and it is the right place to start with.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 18, 2010 at 11:59 am
The simple start will be to update statistics and reorganize indexes on the database. It helps me in most cases when I inherit databases from other environments.
If this doesn't help the next step will be to find out what is the bottleneck (CPU, I/O or memory).
December 18, 2010 at 2:43 pm
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply