• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

How Does Disabling an Index Affect the Index Usage DMV Counters

May 28, 2014 by John Sansom 6 Comments

IndexLetters

A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the SQL Server Dynamic Management Views(DMVs)? Great question! Not one that is straightforward to answer via the Twitter medium though, so I wanted to share some more detail here. Consider that the action of disabling a SQL Server Index […]

Filed Under: Administration, DMVs, SQLServerCentral Syndication, SQLServerPedia Syndication

How much memory is each SQL Server database using?

June 25, 2010 by John Sansom 18 Comments

Whilst perusing the forums over at SQL Server Central today I stumbled across an interesting question regarding how to identify how much memory is being used by SQL Server on a per database level. As you know SQL Server stores database data and index pages in memory in an area know as the Buffer Pool. […]

Filed Under: DMVs, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: DMV

SQL Snippet: SQL Server Wait Types

December 29, 2009 by John Sansom 5 Comments

Here is a handy little SQL Snippet that will return information about those all important SQL Server Wait Types for your server. It uses the SQL Server Dynamic Management View (DMV) sys.dm_os_wait_stats in order to extrapolate the desired information. A column has also been added to provide details of the percentage of total wait time […]

Filed Under: DMVs, SQL Server Tips, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: DMV

DMV Query to identify all active SQL Server Sessions

June 3, 2009 by John Sansom 9 Comments

You may already be aware that I am a big advocate of the SQL Server Dynamic Management Views (DMV’s) and the benifits that they bring to the Database Administrator. They certainly came in handy with a requirement I had recently whereby I needed to identify the IP Address of a specific SQL Server Login and […]

Filed Under: DMVs, SQL Server Tips, SQLServerCentral Syndication, SQLServerPedia Syndication Tagged With: DMV

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy