Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SELECT STATMAN in profiler ???? Expand / Collapse
Author
Message
Posted Thursday, October 16, 2003 3:03 PM
SSC-Enthusiastic

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

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, 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
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:09 PM
Points: 40,193, Visits: 36,597
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
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: Friday, September 12, 2014 12:58 PM
Points: 8, Visits: 209
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 »

Add to briefcase

Permissions Expand / Collapse