February 9, 2010 at 6:21 am
please suggestion me, how to Identify which tables or indexes are poorly designed?
Thanks in advance (SQLDBAs)
February 9, 2010 at 6:45 am
I am not sure if there is a straight way in finding what you wanted. There must have been any workarounds for this given by someone..
Since you have posted this question in SQL 7/2000 forum, I assume it is not SQL Server 2005 /2008, where you have Dynamic Management Views that would have helped.
The way I try to figure out slow performing queries would be running a trace and finding out the queries / stmts that are running for longer duration.. But keep in mind, that running a trace on SQL Server (using Profiler) would have a performance impact, so due diligence needs to be applied.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 9, 2010 at 6:53 am
presuming this is SQL2000....
under tools-wizards you have the index tuning wizard, create a standard profiler trace of normal activity on your server and run it through the wizard see what it says about index requirements. don't take its findings as gospel but its a good starting point.
You can use it for individual queries too if you identify your worst performing queries.
---------------------------------------------------------------------
February 9, 2010 at 7:05 am
Start by identifying queries that are performing badly.
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