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: Friday, December 5, 2014 4:31 PM
Points: 117, Visits: 587
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: Friday, December 12, 2014 8:24 AM
Points: 2,818, Visits: 2,567
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: Friday, October 24, 2014 6:15 AM
Points: 23, Visits: 59
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: Tuesday, December 9, 2014 7:53 AM
Points: 49, Visits: 850
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: Tuesday, December 9, 2014 7:53 AM
Points: 49, Visits: 850
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: Tuesday, December 9, 2014 7:53 AM
Points: 49, Visits: 850
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:20 PM
Points: 18,064, Visits: 16,099
Nice article Ian. Thanks.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #895986
Posted Saturday, April 3, 2010 5:23 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, December 12, 2014 8:24 AM
Points: 2,818, Visits: 2,567
Thanks Ian. I will definitely check it out.
Post #896342
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse