March 2, 2009 at 1:59 am
Hi,
Im sqldba newbie,
can any one help me ,
what r the issues that are commonly facing by D.B.A ,
like blocking,rebuilding indexes?
also i want to know how to identify indexes.....that they r deleted.
before rebuliding indexes.
thanks
March 2, 2009 at 4:45 am
That's way more information than can be easily answered in a post on a board. Performance tuning has three major areas of concern, the OS & Server, which you usually fix once & forget about them, the database structure, where you spend tons of time worrying about clustered indexes, nonclustered indexes, partitioning, compression, etc., and finally the code, where you have to worry about the proper use of syntax and use of the indexes created...
You see what I mean? There's a lot of information to go through here. I'd strongly suggest you pick up several books. The one's I use the most are the Inside SQL Server series. They're all good and useful, each in it's way. Start there. Then when you have specific questions, come back here and post on the board.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
March 2, 2009 at 5:28 am
Thanks
March 3, 2009 at 7:29 pm
You can start with installation of "SQL Server 2005 Performance Dashboard Reports" download from following link.
You can go through all the reports and ofcourse to understand the problem and come up with proper resolution, you need to gain lots of knowledge.
Hope this will help you.
Regards,
Daxesh
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply