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 «««1234»»

Get Performance Tips Directly From SQL Server Expand / Collapse
Author
Message
Posted Thursday, February 4, 2010 6:21 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 11:16 AM
Points: 117, Visits: 567
Thanks for this helpful utility.

Just a heads-up: on our 8-way 64-bit cluster that's rarely rebooted and the cache is rarely flushed, it takes about 4 mins to run this...

Worth the wait, though
Post #860082
Posted Friday, April 2, 2010 7:26 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:41 AM
Points: 2,818, Visits: 2,553
Great article, very useful information.

Over time it has become clear to me that there is gold in them thar system tables. I wonder if anyone could point me to a reference specifically about the system databases, what is contained and where, and how best to mine that gold.

Thanks.
Post #895593
Posted Friday, April 2, 2010 8:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 1, 2013 10:50 AM
Points: 23, Visits: 57
I realize that this is an older post but I discovered it just now when it came in the recent mailing.

My problem with this.

getting error on the following line:
CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) st

I have my compatibility set to 90.

Any ideas. I tried this in both 2005 and 2008
Post #895646
Posted Friday, April 2, 2010 8:23 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, July 6, 2012 7:03 AM
Points: 78, Visits: 168
Curious...

It's telling me it's missing an index: Table InventoryGrouping, Column ClassValuePK, but I already have an index:

CREATE NONCLUSTERED INDEX [IXClassValuePK] ON [dbo].[InventoryGrouping] 
(
[ClassValuePK] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

What am I not understanding here?


Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.
Post #895655
Posted Friday, April 2, 2010 8:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 10:03 PM
Points: 48, Visits: 836
Hi,

What is the error you're getting?

Do you have access to the DMVs? You need VIEW SERVER STATE permission.

Thanks
Ian
Post #895678
Posted Friday, April 2, 2010 8:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 10:03 PM
Points: 48, Visits: 836
Hi,

What index does it say is missing? You should be able to see it's definition in the cached plan.

Thanks
Ian
Post #895680
Posted Friday, April 2, 2010 8:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 10:03 PM
Points: 48, Visits: 836
Hi dbowlin,

Have a look at www.manning.com/stirk I'm working on a book containing about 100 sample scripts similar to the one in the article. You can download the first chapter (with some nice samples) for free.

Thanks
Ian
Post #895683
Posted Friday, April 2, 2010 9:05 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, July 6, 2012 7:03 AM
Points: 78, Visits: 168
Um, I don't know. Can't seem to get the same result from the stored procedure again.

Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.
Post #895700
Posted Friday, April 2, 2010 2:19 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:30 AM
Points: 21,209, Visits: 14,892
Nice article Ian. Thanks.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #895986
Posted Saturday, April 3, 2010 5:23 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:41 AM
Points: 2,818, Visits: 2,553
Thanks Ian. I will definitely check it out.
Post #896342
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse