Viewing 15 posts - 631 through 645 (of 1,518 total)
Here is what I'm running to get the cached plan for the proc of interest:
DECLARE @procName VARCHAR(1000);
SET @procName = '%xxxxxxxxxxxxx%'
SELECT
P.usecounts
,P.plan_handle
,H.query_plan
,LEFT([sql].[text], 1000) as [text]
FROM
sys.dm_exec_cached_plans P
CROSS...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
May 4, 2009 at 2:28 pm
Thank you, I'm actually looking at a cached plan but can't find an XML tag called PARAMETERLIST.
I also looked for "ParameterCompiledValue" but got no hits in the XML.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
May 4, 2009 at 2:23 pm
I should also mention that there is no other session currently running on the user database except for CHECKPOINT, so there is no user activity, neither has there been any...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
May 1, 2009 at 3:26 pm
But is it normal to have this SPID continuously running for so many days?
I actually issued the CHECKPOINT command and did see a spike in the perfmon counter, after which...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
May 1, 2009 at 3:04 pm
I'm getting 0 Checkpoint pages/sec
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
May 1, 2009 at 2:50 pm
David Benoit (5/1/2009)
Marios Philippopoulos (5/1/2009)
I can actually do backups of the db on which the CHECKPOINT is running and run DBCC commands.
It seems the CHECKPOINT session is just hung and...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
May 1, 2009 at 2:22 pm
SQLBOT (4/30/2009)
IF a checkpoint is stuck that means you can't get a backup. can't run a dbcc, etc.
I've had this happen once, tried everything...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
May 1, 2009 at 2:15 pm
David Benoit (5/1/2009)
Are you suffering from IO latency? Also curious what your CPU looks like. Can you provide some of that information?
Not sure if it is an IO problem.
CPU...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
May 1, 2009 at 2:13 pm
SQLBOT (4/30/2009)
IF a checkpoint is stuck that means you can't get a backup. can't run a dbcc, etc.
I've had this happen once, tried everything...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
May 1, 2009 at 12:20 pm
David Benoit (4/30/2009)
...and an interesting post on this can be found HERE
Thanks for all the info!
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 30, 2009 at 3:40 pm
David Benoit (4/30/2009)
Yup. There are other issues with this being virtual and this is just one of several warning signs which concerns me.
Slightly off topic, but what other issues...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 30, 2009 at 3:10 pm
David Benoit (4/30/2009)
I have a...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 30, 2009 at 3:01 pm
David Benoit (4/30/2009)
Is this a virtual server?
No, it's a physical server.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 30, 2009 at 2:57 pm
Thomas LaRock (4/28/2009)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 28, 2009 at 12:46 pm
I'm currently having a performance problem related to SCOM that I'm trying to resolve.
Procedure sp_spaceused appears to be consuming a lot of tempdb space in my SQL 2000 instance, to...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 28, 2009 at 10:41 am
Viewing 15 posts - 631 through 645 (of 1,518 total)