Theo's MS-SQL tookit blog

A blog dedicated to usefull MS-SQL scripts and snipppets
  • To my photo site
  • About

Looking for a a downloadable list of SQL BUILDS ?

2019-10-06
Maintenance Patching

Look no further, i have made one http://sqlbuilds.ekelmans.com/ It is automatically updated every 2 hours, based on the excellent sqlserverbuilds.blogspot.com site Enjoy,T.

Read Post No Comments

SP; search Query plan cache for issues, like table scans, missing indexes or stats

2014-03-02
Performance Plan cache Stored procedure

SP; search Query plan cache for issues, like table scans, missing indexes or stats, or any other command

Read Post No Comments

What is the Used, Free and Reserved space per DB / LOG

2014-03-02
Dir, file or folder Disk Log Performance

What is the Used, Free and Reserved space per DB / LOG

Read Post No Comments

Relative load per DB in CPU, IO and CLR

2014-03-01
CPU Disk Performance

What is the relative load per DB in CPU, IO and CLR?

Read Post No Comments

Actual (sparse) file size on disk of a snapshot

2014-03-01
Dir, file or folder Disk Overview Snapshot

What is the actual (sparse) file size on disk of a snapshot?

Read Post No Comments

Determine the page life expectancy per NUMA node

2014-03-01
Memory Overview Performance

Determine the page life expectancy per NUMA node (is it balanced?)

Read Post No Comments

Disk usage per DB per Driveletter pivot

2014-03-01
Disk Performance

Displays the IO in bytes per database per drive [table id=3 /]

Read Post No Comments

Diskspace Free and Total overview

2014-03-01
Disk Overview

Displays the free space,free space percentage plus total drive size for a server [table id=2 /]

Read Post No Comments

CPU history (256 minutes)

2014-03-01
CPU Performance

Show the CPU load in last 256 minutes

Read Post No Comments

Plan cache per DB

2014-03-01
Memory Performance Plan cache

How much memory each DB is using for sql plan cache?

Read Post No Comments
« Older posts

Recent Posts

  • Looking for a a downloadable list of SQL BUILDS ?
  • SP; search Query plan cache for issues, like table scans, missing indexes or stats
  • What is the Used, Free and Reserved space per DB / LOG
  • Relative load per DB in CPU, IO and CLR
  • Actual (sparse) file size on disk of a snapshot

Archives

  • October 2019
  • March 2014

Recent Comments

    Categories

    • Buffer
    • CPU
    • Dir, file or folder
    • Disk
    • Log
    • Maintenance
    • Memory
    • Overview
    • Patching
    • Performance
    • Plan cache
    • Snapshot
    • Stored procedure

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
    Asteroid Theme