Show Database ID in SQL Server

 The query below can retrieve database id by supplying the database name

-- Show database id using system view

 SELECT database_id FROM sys.databases

 WHERE name = '<db_name>';




-- Show database id using function

SELECT DB_ID('<db_name>');




Check for CPU Pressure in SQL Server

 The following query shows resource wait time and signal wait time both in value and in percentage. This is particularly useful in ascertaining if there is CPU pressure in your SQL Server. A higher signal wait time percentage can be a sign of CPU pressure or need for faster CPU on the server.

select

SUM(signal_wait_time_ms) as total_signal_wait_time_ms,

SUM(wait_time_ms - signal_wait_time_ms) as resource_wait_time_ms,

SUM(signal_wait_time_ms) * 1.0/SUM(wait_time_ms) *100 as signal_wait_percent,

SUM(wait_time_ms - signal_wait_time_ms) * 1.0 /SUM(wait_time_ms) * 100 as resource_wait_percent

from sys.dm_os_wait_stats

SQL Server Database migration checklist

Pre Migration Checklist 

• Analyze the disk space of the target server for the new database.
• Confirm the data and log file location for the target server.
• Collect the information about the Database properties (Auto Stats, DB Owner, Recovery Model, Compatibility level,etc).
• Collect the information of dependent applications, make sure application services will be stopped during the database migration.
• Collect the information of database logins, users and their permissions.
• Check the database for the Orphan users if any.
• Check the SQL Server for any dependent objects (SQL Agent Jobs and Linked Servers).
• Check, if the database is part of any maintenance plan.

Database Migration Checklist

• Stop the application services.
• Change the database to single user mode.
• Take the latest backup of all the databases involved in migration.
• Stop the SQL Services on live server.
• Copy the backup from live to destination server.
• Restore the databases on the target server on the appropriate drives.
• Cross check the database properties as per pre-migration checklist output.
• Execute the output of Login transfer script on the target server, to create logins on the target server.
• Check for Orphan Users and Fix Orphan Users. 
• Execute DBCC UPDATEUSAGE on the restored database.
• Rebuild Indexes ,As per the requirement.
• Update statistics.
• Recompile procedures.
• Configure Full backup, Log backup, integrity check, rebuild index jobs.

Post Migration Checklist

• Check the integrity of database.
• Start the application services, check the application functionality.
• Check the SQL Server Error Log for login failures and other errors