Dear Sujeet,
Can you please suggest how to find the fragmentation level by using command prompt? Thanksin advance for your help.
Regards,
Kolla Srikanth
SQL DBA Guru
“Your issues, Our solutions”
Script to find out the SQL Server Fragmentation Level
Posted January 19, 2012
Comments
Hi Kolla,
Thanks for putting up your question here. Here is the SQL Script to know the fragmentation level of any table and its indexes. Also note that it gives the details about the fragmentation in percentage.
DECLARE @db_id INT;
DECLARE @object_id INT;
SET @db_id = db_id(N'Database Name');
SET @object_id = OBJECT_ID(N'Table Name');
BEGIN
SELECT *
FROM sys.dm_db_index_physical_stats(@db_Id, @object_ID, NULL, NULL , 'DETAILED') AS SKS;
END
GO
Hope this answers your query.
Regards,
Sujeet
Displaying 1 comment
Add comment
Get the Expert's Advice.
Don't wait until you have got problems. Get the expert's advice, optimize your SQL Server and relax.
Contact for a SQL Sever Health Checkup Guidance today!
Always reachable through:
- - A Live Chat Session every Mondays and Thursdays.
- - Call at 88-26-648-648 Dial 0091 before the number while calling from outside India.
- - Mail me your questions at question@sqldbaguru.com