Viewing 15 posts - 1,156 through 1,170 (of 1,518 total)
Yes, links don't work any more. Any chance they can be restored?
__________________________________________________________________________________
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 29, 2008 at 7:20 am
Thanks guys, cheers!
__________________________________________________________________________________
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 28, 2008 at 2:03 pm
Do I have to RDP to the actual server for this to work?
I just did that and it worked!
Does that mean DAC only works once one is collected locally...
__________________________________________________________________________________
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 28, 2008 at 1:57 pm
Wilfred van Dijk (5/28/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 28, 2008 at 9:46 am
May I suggest a couple of great links on this topic, ones that have helped me tremendously?
Gathering Unused Index Information:
mhtml:http://www.grumpyolddba.co.uk/sql2005/working%20with%20indexes%201.mht
Uncover Hidden Data to Optimize Application Performance:
http://msdn.microsoft.com/en-us/magazine/cc135978.aspx
__________________________________________________________________________________
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 28, 2008 at 9:33 am
Thank you for the response and link. That link was actually what prompted my opening post.
Any info on NUMA architecture as it relates to SQL Server performance?
Any experiences anyone wishes...
__________________________________________________________________________________
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 28, 2008 at 8:10 am
Manie Verster (5/28/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 28, 2008 at 8:08 am
Wilfred van Dijk (5/27/2008)
Also make sure you have a minimum and maximum size. Don't set the maximum size to unlimited,...
__________________________________________________________________________________
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 28, 2008 at 8:01 am
Here is a query you can use.
Make sure your SQL instance has been up for at least 1 business cycle (week/month/longer???) before you start eliminating indexes! :w00t:
SELECT
OBJECT_NAME(...
__________________________________________________________________________________
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 27, 2008 at 3:19 pm
Steve Jones - Editor (5/27/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 27, 2008 at 2:45 pm
To get the total current size of your buffer pool run the following:
SELECT
SUM( multi_pages_kb +
virtual_memory_committed_kb +
shared_memory_committed_kb +
awe_allocated_kb ) AS [Used by BPool, KB]
FROM
sys.dm_os_memory_clerks
WHERE
[type] = 'MEMORYCLERK_SQLBUFFERPOOL'
Taken...
__________________________________________________________________________________
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 27, 2008 at 2:31 pm
I would also add, be wary of indexes defined on too many keys (more than 3). These are usually overkill, unless you need a covering index.
Also, as Gail mentioned,...
__________________________________________________________________________________
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 27, 2008 at 2:05 pm
jeff.williams3188 (5/22/2008)
That is interesting - since everything I can find says that statistics on indexes will be rebuilt with a full scan.Jeff
I ran "dbcc show_statistics" on some of the 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]
May 22, 2008 at 1:25 pm
rbarryyoung (5/22/2008)
I agree, it's confusing. I am not sure what the answer is either.
No problem, thank you for responding.
I will be making the case for SQLCLR in an upcoming...
__________________________________________________________________________________
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 22, 2008 at 11:43 am
jeff.williams3188 (5/22/2008)
If I switch from sysindexes to sys.indexes, I have no access to information as to how many rows in the index have been modified since the latest update. 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 22, 2008 at 11:30 am
Viewing 15 posts - 1,156 through 1,170 (of 1,518 total)