SELECT STATMAN in profiler ????

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Notification Services » Administration » SELECT STATMAN in profiler ????

SELECT STATMAN in profiler ????

Rate Topic

Display Mode

Topic Options

Author

Message

peddi_praveen

Posted Thursday, October 16, 2003 3:03 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 20, 2004 11:57 AM
Points: 114, Visits: 1

hi guys,
while i run a Stored Proc and profiling this , i had encountered these kinda statements.

SELECT statman([ListingAddressPostalCode],[ListingAddressStreetNumber],[ListingAddressStreetName],[ListingAddressUnitNumber],[DataSourceID],[AMListingID],@PSTATMAN)
FROM (SELECT TOP 100 PERCENT [ListingAddressPostalCode],[ListingAddressStreetNumber],[ListingAddressStreetName],[ListingAddressUnitNumber],[DataSourceID],[AMListingID] FROM [dbo].[LISTING] WITH(READUNCOMMITTED,SAMPLE 1.000000e+002 PERCENT) ORDER BY [ListingAddressPostalCode],[ListingAddressStreetNumber],[ListingAddressStreetName],[ListingAddressUnitNumber],[DataSourceID],[AMListingID]) AS _MS_UPDSTATS_TBL OPTION (BYPASS OPTIMIZER_QUEUE, MAXDOP 1)

any help would be appreciated.

Praveen Kumar Peddi

Praveen Kumar Peddi

Post #17367

Site Owners

Posted Monday, October 20, 2003 8:00 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

Post #83682

Amulya

Posted Wednesday, March 26, 2008 4:17 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 03, 2012 4:51 AM
Points: 24, Visits: 74

Hi ,

we too feel the same.. There is only one update which doesn't involve any indexes or any other statemets..For Simple update like the below , it is listing the above statements..

update a
set TotalQty = Tqty
from XXX_item_wise_taxes_tabl a,
(select invoice_no Tinvoice_no, sum(invoice_qty) TQty from XXX_item_wise_taxes_tabl group by invoice_no) b
where invoice_no = Tinvoice_no.

Any guesses

Post #474596

GilaMonster

Posted Wednesday, March 26, 2008 4:28 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:21 AM
Points: 37,686, Visits: 29,943

What you're seeing is an automatic statistics update. Nothing to be concerned about.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #474600

Rottengeek

Posted Thursday, March 03, 2011 2:28 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:50 PM
Points: 8, Visits: 189

i'm seeing this, too - the problem is, we are having i/o issues and this is one of the highest i/o operations going.

One thing to note is that "Auto Update Stats" is off, and this appears to be called from SQL Agent, although i have been unable to find a job. It's happening every 15 minutes.

Where can it come from?

Amanda

Post #1072935

« Prev Topic | Next Topic »

Permissions