Viewing 15 posts - 226 through 240 (of 1,518 total)
Jack Corbett (8/30/2011)
__________________________________________________________________________________
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]
August 30, 2011 at 2:29 pm
Here is a script that cycles though all databases running the DMV query on each one separately and storing the results into a temp table for final retrieval;
this is the...
__________________________________________________________________________________
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]
August 29, 2011 at 2:45 pm
BrentMc (8/29/2011)
I suspect that it is your join that is causing this. Can you supply the query that you are using?
Sure, here it is:
--"Performance Tuning with SQL Server Dynamic Management...
__________________________________________________________________________________
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]
August 29, 2011 at 2:29 pm
GilaMonster (8/27/2011)
Or loop through and create a temp table with all of the sys.partitions (partition_id, database_id, object_id, index_id) in it and join to that.
Good idea, I'll try it both ways...
__________________________________________________________________________________
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]
August 27, 2011 at 8:04 am
Only way I can think of is to loop through all databases in the SQL instance and issue the sys.dm_tran_locks query filtering by resource_database_id.
Store the intermediate results in a temp...
__________________________________________________________________________________
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]
August 27, 2011 at 6:10 am
GilaMonster (8/26/2011)
sys.partitions is a per-database view. Not per-server. That join is only a valid one if you're running that in the DB that has the locks.
So is there a way...
__________________________________________________________________________________
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]
August 26, 2011 at 3:30 pm
Thanks, your suggestion is working.
Still getting NULLs, but not as many as before:
SELECT
DTL.[resource_type] AS [resource type] ,
...
__________________________________________________________________________________
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]
August 26, 2011 at 3:08 pm
What error are you getting?
I have always done this within stored procedures, not views.
Is there a reason you are using a view instead of a sproc to do this?
__________________________________________________________________________________
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]
August 24, 2011 at 2:28 pm
I still haven't figured this out; any ideas anyone?
Here is a link that describes how I am doing this through SQL Profiler UI:
http://msdn.microsoft.com/en-us/library/ms179321(v=SQL.100).aspx
However, when I attempt to save it as...
__________________________________________________________________________________
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]
August 22, 2011 at 12:31 pm
GilaMonster (8/22/2011)
I said that just because Microsoft recommends something does not mean that you must go out and do it. (There have been very...
__________________________________________________________________________________
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]
August 22, 2011 at 11:06 am
GilaMonster (8/21/2011)
When my data is in cache already (which hopefully is most of the time)
When a query is only using the clustered indexes...
__________________________________________________________________________________
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]
August 22, 2011 at 10:33 am
No, trace flag 2861 is not enabled.
Also, these are not 0-cost plans. For example, I'm getting the issue for XML that is 12,002 lines long from start to finish.
I'm also...
__________________________________________________________________________________
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]
August 22, 2011 at 9:45 am
GilaMonster (8/20/2011)
Marios Philippopoulos (8/20/2011)
Jeffrey Williams-493691 (8/20/2011)
I see this a lot, and the assumption by the person is that...
__________________________________________________________________________________
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]
August 21, 2011 at 6:01 am
awu (8/17/2011)
__________________________________________________________________________________
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]
August 21, 2011 at 5:48 am
Grant Fritchey (8/20/2011)
Just a guess, any chance that the database is in compatibility mode? I'm not sure that would affect anything, but that's odd behavior.
Odd indeed...
Db is on 100 comp...
__________________________________________________________________________________
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]
August 20, 2011 at 3:33 pm
Viewing 15 posts - 226 through 240 (of 1,518 total)