Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paishwarya
Starting Member
4 Posts |
 Posted - 2010-10-27 : 13:50:50
|
| how do I find the Fragmentation % on the database level and on the disk level for sql server 2005 |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
|
|
paishwarya
Starting Member
4 Posts |
Posted - 2010-11-01 : 10:25:37
|
| Thanks, also how do I find the fragmentation % on the C drive or D drive files. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-11-01 : 11:51:47
|
quote:
Originally posted by paishwarya
Thanks, also how do I find the fragmentation % on the C drive or D drive files.
Use the Windows Disk Defragmenter utility to view the fragmentation.CODO ERGO SUM |
|
|
|
|
|
|
Fragmentation %