Search Results | SQL Server Performance Forums

How to reduce the CPU Time of procs

Thread by: Aston, Jul 9, 2008, 5 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi , Proc using Dynanic SQL are taking alot CPU time . Can any one guide how to reduce it? Thanks

TSQL Improvements during upgradtion to SQL2005 from SQL2000

Thread by: Aston, Jun 17, 2008, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi Experts, We are upgrading to SQL2005 from SQL2000. So I need to review the TSQL of existing procs to incorprating new features of SQL2005 for...

Plan caching in case of diff. values for if conditions..

Thread by: Aston, May 28, 2008, 1 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hello all, Quick question: If in a proc in SQL Server 2005 there are multiple if conditions like Create proc A @p1 int AS Begin if @p1=1 select...

Is there any tutorial on the internet that can help me understanding XML execution plan thorughly ?

Thread by: Aston, May 23, 2008, 3 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi , Is there any tutorial on the internet that can help me understanding XML execution plan thorughly ? Thanks,

Is it good to have columns of type bit in composite indexes ?

Thread by: Aston, May 1, 2008, 3 replies, in forum: Performance Tuning for DBAs

Hi, Is it good to have columns of type bit in the composite indexes like (col1,col3,bit-cloumn,col5,col7 etc.) ? Thanks

How to see by how much frequecy the index is being used by the optimizer...

Thread by: Aston, Apr 30, 2008, 2 replies, in forum: Performance Tuning for DBAs

Hi , In SQL SERVER 2000 , How can we see that the indexes built by us are being utilized by query optimizer. Means i want to identify the indexes...

Reading cached execution plans in SQL SERVER 2000

Thread by: Aston, Apr 24, 2008, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi , As we can use dmv in SQL Server 2005 to read cached Execution plans(in xml). which table in SQL 2000 gives the same information ? Thanks!!!

find out the sql statments that caused index scans, table scans etc...

Thread by: Aston, Apr 20, 2008, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi Gurus, when we run queires , the plan used by optimizer inserted into sys.dm_exec_text_query_plan. I want to extract the queries that used index...

Identify bookmark lookups in SQL 2005 in XML Plan

Thread by: Aston, Apr 14, 2008, 1 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi , In SQL Server 2005, in the execution plan instead of showing bookmark lookups its says ClusteredIndex Seek if the table has clustered index....

Clustered Index Update..

Thread by: Aston, Apr 9, 2008, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

UPDATE tblx SET C1 = 5, C2 = GETDATE(), C3 = GETDATE(), C4 = 2 WHERE (C7 = 24) AND (C8 = 1) There is PK Clustered on column "ID". When ever we...

Analysis of Set Statistics IO ON output...

Thread by: Aston, Apr 6, 2008, 4 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi , I have run the sp using SET STATISTICS IO ON and got following output:Table 'Worktable'. Scan count 2, logical reads 597, physical reads 0,...

Analysis of Set Statistics Time on output...

Thread by: Aston, Apr 6, 2008, 4 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi I have run a procedure using SET STATISTICS TIME ON and got following:SQL Server parse and compile time: CPU time = 0 ms, elapsed time = 3 ms. SQL...

advantage of duplicating Clustered key in non clustered index..

Thread by: Aston, Mar 31, 2008, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, I have a table havnig clustured index in indentity column C1. If i make another non clustered index COMBINED on onther columns : C4,C3,C6,C1,C8...

Performance of index ...

Thread by: Aston, Mar 30, 2008, 3 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi , I got a Index usage report using DMV in which few indexes got 0 value in all fields (User_Scans,Lookups,Seeks etc.). What does it mean and what...

Effects of Partition of existing Table...

Thread by: Aston, Mar 30, 2008, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I want to make partition of a table on some criteria. does there any changes in the existing Queries/SPs for accessing the table or SQL Server...