September 28, 2011 at 9:17 am
Hello Friends, I am working on a SQL review process and need to prepare a document which will help us to point out any possible Hardware or Performance issue before implementing anything new related to SQL into the environment. For example –if we are creating a new Table or Database what are the things we should consider or if we are creating a new procedure or updating an existing one.. what are the things we should consider or if we have any performance related issues.. where to start from? What are the important things we should consider for performance improvement and so on… I am kind of new to all this and I would really appreciate your help on this---Please help
September 28, 2011 at 10:46 am
That's a big list, I don't think you're going to find a single source for all of it. My book on query tuning has a performance checklist that might help, but it's maybe 1/5th of what you're looking for. However, the one source you want to consider is Brad McGehee. For example here is a monitoring checklist[/url], and this is a maintenance checklist[/url], there are others.
Primarily these are for recording where you are, not for telling you where you should be.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply