Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SELECT STATMAN in profiler ???? Expand / Collapse
Posted Thursday, October 16, 2003 3:03 PM


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
Posted Monday, October 20, 2003 8:00 AM


Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,041, 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
Posted Wednesday, March 26, 2008 4:17 AM


Group: General Forum Members
Last Login: Friday, July 26, 2013 12:04 AM
Points: 24, Visits: 76
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
Posted Wednesday, March 26, 2008 4:28 AM



Group: General Forum Members
Last Login: Today @ 12:12 AM
Points: 45,618, Visits: 44,146
What you're seeing is an automatic statistics update. Nothing to be concerned about.

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

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

Post #474600
Posted Thursday, March 3, 2011 2:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 11, 2015 12:09 PM
Points: 8, Visits: 228
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?

Post #1072935
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse