Viewing 15 posts - 1,186 through 1,200 (of 1,518 total)
Grant Fritchey (5/16/2008)
__________________________________________________________________________________
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 16, 2008 at 12:07 pm
Grant, thanks so much for all this info, this is great!
I will definitely look at the links you have posted and make use of them. It's also great to know...
__________________________________________________________________________________
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 16, 2008 at 11:59 am
Thank you all for the great turnout and discussion, please keep it coming! 🙂
__________________________________________________________________________________
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 16, 2008 at 9:56 am
Here is the modified query I use to determine which indexes in my database to run UPDATE STATS on:
SELECTid
,indid
,OBJECT_NAME(id)
,[name]
,rowcnt
,rowmodctr
,STATS_DATE(id, indid) AS Date_LastUpdated
FROM sys.sysindexes WITH ( NOLOCK )
WHERE indid > 0...
__________________________________________________________________________________
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 16, 2008 at 8:09 am
Another question I have on this issue:
Is there a performance hit when SQLCLR objects are invoked from code residing on another database on the same instance? In other words, is...
__________________________________________________________________________________
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 16, 2008 at 7:01 am
tom (5/15/2008)
I don't want to have to mod the script every time I...
__________________________________________________________________________________
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 16, 2008 at 6:57 am
Just got notice on this interesting link:
Tips for moving from SQL Server local disk storage to SANs:
__________________________________________________________________________________
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 15, 2008 at 11:28 am
TheSQLGuru (5/15/2008)
Oh, and for this one "It's as if people naively think the tool itself will solve all their problems with no tuning necessary. I've witnessed this all too...
__________________________________________________________________________________
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 15, 2008 at 11:17 am
TheSQLGuru (5/14/2008)
colin Leversuch-Roberts (5/14/2008)
__________________________________________________________________________________
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 15, 2008 at 10:34 am
The SSIS package I created loops through a table containing the server instances and local paths to which I wish to deploy the SQL CLR objects and dll file and:
(1)...
__________________________________________________________________________________
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 15, 2008 at 8:00 am
The only extra thing I can think of right now is tempdb usage. In SQL 2005 tempdb usage is greatly increased. Make sure tempdb in the new SQL 2005 instance...
__________________________________________________________________________________
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 14, 2008 at 11:03 am
At the very least, you must update the stats.
__________________________________________________________________________________
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 14, 2008 at 10:41 am
anthony.green (5/14/2008)
The server still shows 16 in the lowest value for max server memory but the maximum shoots back up 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]
May 14, 2008 at 10:37 am
After changing the compatibility level to 90, do the following:
(1) At the very least run sp_updatestats on all user databases, OR preferably run:
UPDATE STATISTICS WITH FULLSCAN on all user databases.
(2)...
__________________________________________________________________________________
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 14, 2008 at 10:32 am
dsc (5/14/2008)
It'll most end in answers like "It's not the SAN, it's it usage by applications". It's also almost impossible to get a meanigful overview of the current SAN workload.
These...
__________________________________________________________________________________
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 14, 2008 at 7:30 am
Viewing 15 posts - 1,186 through 1,200 (of 1,518 total)