September 19, 2006 at 6:50 am
I was wondering if anyone has experience with providing a high level analysis of a prospective client's database. I guess what I'm looking for is a checklist. This is what i have so far...
1) Check DB size (data and log files)
2) Check for Disaster Recovery and Maintenance plans
3) Check tables for use of Keys and Indexes.
4) Need advice on how to quickly check for the cause of common performance issues...
I've never been asked to provide a quick assessment on possible database issues with no more than a "things are running slow" comment and the database scripts. I will not have the ability to monitor the server performance during the assessment period.
September 19, 2006 at 2:17 pm
You could use the sql server best practices analyzer on the db. It will report which stored procedures,views needs some work. Like owner not specified ...
Perhaps you will have access to the business logic, the order in which the queries are sent.
Estimated queryplans?
Too bad you won't be able to monitor the actual performance.
September 20, 2006 at 8:46 am
That's what i was thinking. I'm going to push for a more specific list of issues and perhaps a profiler...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply