7. February 2009 11:12
By
robault
In
SQL | TSQL
Image via Wikipedia
What a SQL re-indexing process should be doing:
1. Re-indexing indexes or tables over 30% fragmentation (BOL). Some estimates are 15-20% or more.
2. Reorganizing indexes or tables less than 30% fragmented (BOL). Some estimates are 2%-10%.
3. It ap...
[More]
5. February 2009 11:09
By
robault
In
Hardware | IT/IS | SQL | TSQL
Image via Wikipedia
You probably don’t have a DBA on site but you need some DB maintenance.
A DBA is a resource developers hope would be there when their product ships, but most companies don’t realize the importance of having someone actively managing their SQL servers. SQL is good e...
[More]
1. February 2009 10:52
By
robault
In
SQL | IT/IS | Hardware
Image via Wikipedia I can’t imagine anyone actually doing this but based on what I’ve read online, this might represent the highest degree of performance with the highest degree of fussiness in hardware setup: Physical Disk 1: OS – the reason is obvious I think Physical Disk 2: OS swap ...
[More]
Be the first to rate this post
- Currently 0/5 Stars.
- 1
- 2
- 3
- 4
- 5
Tags: