Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Profiler statement is it harmful for performance ?

Author  Topic  DMP Starting Member 41 Posts Posted - 2006-01-11 : 02:48:28 Hi, In Query Profiler I notice many following sort of statment execute by SQL Server: SELECT statman([TrnchId],[AcctId],[AllocClassId],[SeriesId],[TaxbucketId],[ItmId],[ChngId],[PrtnrId],@PSTATMAN) FROM (SELECT TOP 100 PERCENT [TrnchId],[AcctId],[AllocClassId],[SeriesId],[TaxbucketId],[ItmId],[ChngId],[PrtnrId] FROM [dbo].[Srs_AllocTrancheExpns] WITH(READUNCOMMITTED,SAMPLE 1.000000e+002 PERCENT) ORDER BY [TrnchId],[AcctId],[AllocClassId],[SeriesId],[TaxbucketId],[ItmId],[ChngId],[PrtnrId]) AS _MS_UPDSTATS_TBL OPTION (BYPASS OPTIMIZER_QUEUE, MAXDOP 1) Is it harmful for performance ? How can i avoid above statement ? Thanks...