top of page

This site was designed with the

website builder. Create your website today.Start Now

DBADude

To The Cloud and Beyond

Performance

Server and Database Settings

•See Installation's server settings: memrory, auto growth, parallelism, etc…
Set initial database size and growth size appropriatedly

SQL Server Profiler

Monitor Highest Total Execution Time, capture Stored Procedure or Query
Run trace on the captured Stored Procedure or Query
Recompile the Stored Procedure or kill the deadlock session
Extended Events and Query Store, in preparation of Azure Databases

Indexes

Monitor unused Indexes. If it is not used, you might want to delete it
Monitor missing Indexes. Add missing indexes if needed
Manage Statistics and re-indexes jobs
10 most expensive queries, mostly requested by your boss and outside influencers

bottom of page