Tag: Dynamic Management Views (DMVs)
This tag groups together all the articles and posts related to SQL Server Dynamic Management Views (DMVs)
-
Identifying SQL Server cross-database dependencies when migrating
Are you moving a database to a different SQL Server? Worried the database might have cross-database dependency on other databases that are not part of this move? This post will show you how to identify any cross-database dependencies as part of your pre-checks for the migration
-
SQL Server ‘max server memory (MB)’ – the magic formula for calculating buffer pool size
As an SQL Server DBA, have you got a formula for calculating the value for ‘max server memory (MB)’ parameter, that restricts the memory used by SQL Server buffer pool? If not, read on and use the script provided in this post, to come up with a suitable value using various different formulae.
-
Script for a quick SQL Server memory overview – useful for creating a snapshot of current memory configuration
This post provides a quick memory overview of your SQL Server. The output includes the total amount of RAM on the SQL Server box, amount of unused RAM at host level, SQL Server memory allocations, current buffer pool and procedure cache sizes.
-
Too many Extended Events sessions? Take control, see what’s running and stop unnecessary sessions
Have you got too many extended events sessions running on your production server? Not sure which ones are running and which ones are needed? Read this article and learn how to take control of your extended events sessions
-
dutyDBA Case Files #1 – Unable to change the database owner on secondary replicas to sa
This case notes is from a real world incident, where a DBA account could not be dropped because it owns the databases on an Always On secondary replica. I investigate how it happened and show you how to resolve it, and prevent it from happening again.
-
Script to generate the setspn commands required to create/register SPNs for Always On & standalone SQL Server service accounts
This article offers a script that generates all the necessary setspn commands required to create the SPNs for Always On and standalone SQL Server instance service accounts. Once you run these setspn commands, the SPNs get created and registered in the Active Directory (AD)
-
In a distributed Always On AG setup, how to check the database synchronisation and health status across all nodes/replicas?
This post shows you how to check the synchronisation and health status of your databases and replicas across a distributed Always On setup. The built-in Always On dashboard does not show this information for distributed Always On setups.
-
How to use sys.dm_io_virtual_file_stats to check the disk read and write performance of your SQL Server?
When it comes to checking how well the disks are performing on your SQL Server, sys.dm_io_virtual_file_stats is your best friend. This Dynamic Management View (DMV)
-
How to check if an SQL Server database is in use?
DBAs often get asked if a particular database is in use, often with a view to dropping any unused databases to save valuable disk space.
Latest Articles
