April 13, 2009 at 12:33 am
Dear All,
I need to finetune somewot a big database (4GB+).
Can any one give some idea on how to go about it..?
Shall I start with Indexes first.? If so, wot are the things to be checked in indexes..?
Please guide me with step by step actions to be taken on indexes.
Sometime back I saw one person executing certain queries step by step while finetuning a server.
Like,
1. Listing out all the indexes..
2. Checking for missing indexes.
3. checkign for IO.
etc.,
He had saved those scripts in sequence....Am looking for something like that as it will be easy to undertsand.
By the way, am not a biginner. I have somewot good idea about database administartion. The problem is that I switched to DBA from development and have NEVER worked with any DBA before, hence there is starting problem any work I do. I learn myself and takes help from this website especialy.
Kindly guide me....
Thanks in advance.
April 13, 2009 at 2:46 am
This is the way I always do it.
No point in tuning queries or indexes that aren't a problem.
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
April 13, 2009 at 3:05 am
Thank you somuch Gila. Think this is I what I was looing for.
I will go thru it..
April 13, 2009 at 8:40 am
Hi Gila,
These are great articles but i am not able to add any comments 🙁
April 13, 2009 at 8:46 am
Vijaya Kadiyala (4/13/2009)
These are great articles but i am not able to add any comments 🙁
I can't help you with that. Mail or PM the Simple Talk people (Tony Davis). It's their site.
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 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply