November 27, 2007 at 11:06 pm
Hi,
I'm new to performance tuning. Could you suggest me the key points that need to be identified for performance issues and the tool to identify???
December 10, 2007 at 11:53 pm
No indexes, table scans, missing or out of date statistics, blocking, excess recompilations of stored procedures, procedures and triggers without SET NOCOUNT ON, poorly written query with unnecessarily complicated joins, too much normalization, excess usage of cursors and temporary tables.
Some of the tools/ways that help you troubleshooting performance problems are: SET SHOWPLAN_ALL ON, SET SHOWPLAN_TEXT ON, SET STATISTICS IO ON, SQL Server Profiler, Windows NT /2000 Performance monitor, Graphical execution plan in Query Analyzer
December 21, 2007 at 5:04 am
I'd suggest you buy the sql 2000 performance tuning manual - sorry not got isbn to hand.
I'd also recommend Idera SQL Diagnostic Manager
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply