Are there any utilities to take care the issues of data fragmentation, especially on SAN storage disks? Thanks for recommendation,
For disk fragmentation check with your SAN vendor where for table/data fragmentation... sql server has commands you can use them... Check books online for syntax of the following commands.. DBCC DBREINDEX DBCC INDEXDEFRAG Microsoft SQL Server 2000 Index Defragmentation Best Practices http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Did you read: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=20562 ?? Luis Martin Moderator SQL-Server-Performance.com All in Love is Fair Stevie Wonder All postings are provided “AS IS†with no warranties for accuracy.
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=20599 too. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.