Slides and links from my session @Techdays in Sweden

As always thanks for attending and for making speaking in Stockholm being a fun thing to do. As promised during the session here are the links to the blog posts I mentioned, the script I used and the slide deck.

SQL Script to for fragmentation on the SQL DB

Checking the database fragmentation:
Use CM_PS1
Go
SELECT DB_NAME(database_id) AS [Database Name], OBJECT_NAME(ps.OBJECT_ID) AS [Object Name],
    i.name AS [Index Name], ps.index_id, index_type_desc,
    avg_fragmentation_in_percent, fragment_count, page_count
FROM sys.dm_db_index_physical_stats(DB_ID(),NULL, NULL, NULL ,N’LIMITED’) AS ps
    INNER JOIN sys.indexes AS i WITH (NOLOCK)
    ON ps.[object_id] = i.[object_id] AND ps.index_id = i.index_id
WHERE database_id = DB_ID()
AND page_count > 1500
ORDER BY avg_fragmentation_in_percent DESC OPTION (RECOMPILE);

By | 2014-11-22T13:17:49+00:00 November 22nd, 2014|Configuration Manager (SCCM), Events|1 Comment

About the Author:

Kent Agerlund

Microsoft Regional Director, Enterprise Mobility MVP. Microsoft Certified Trainer and Principal consultant. I have been working with Enterprise client management since 1992. Co-founder of System Center User Group Denmark in 2009.

Certified MCITP: Enterprise Administrator, MCSA+Messaing, and much more.

Member of: Microsoft Denmark System Center Partner Expert Team The Danish Technet Influencers program System Center Influencers Program.

One Comment

  1. Hampus November 25, 2014 at 9:16 - Reply

    Thanx for the links and thanx for the really great session at Tech Days!

Leave A Comment