Automatically Indexing Millions of Databases in Microsoft Azure SQL Database

Automated SQL Server Indexing at massive scale Read more →

How to use Database Compatibility to increase your migration success

Understanding SQL Server database compatibility levels helps in understanding risk in upgrades Read more →

Most important SQL Server wait types

Before I discuss the most important wait type list , I want to say that really there is no definitive list of most important sql wait types. Understanding what is normal and the context of the wait type is essential when discussing wait types. For example , you may see the sql wait type WRITELOG as high on the list of waits on a SQL Server. This may or may not be important depending on the "normal" behaviour. Benchmarking your systems is a great way of understanding the patterns your systems. Based on monitoring and analysing various SQL Server performance... Read more →

UPDATE STATISTICS GETTING SLOWER

Question: The Statistics tasks in the SQL Server Maintenance plan is getting slower? When I first implemented the task it used to take 1 hr – recently it’s built up 4-5 hrs. I’ve checked underlying resource issues – and everything looks OK. Could you advise on how I can progress with troubleshooting. I’ve included a screeshot of Update Statistics Task. Answer: It is not unusual to find UPDATE STATISTICS getting slower over time. Looking at the way you have this configured All existing statistics – this includes all index and table statistics Sample size of 25 % It is very... Read more →

SQL Server 100 cpu diagnose

Question: Users are reporting long delays in query responses. I checked on the server and noticed CPU counter at 100 % on Performance Monitor. There are 4 cores associated to this server and all the cores were hovering around 100%. How can I diagnose the underlying cause ? Answer: It’s a common problem faced by DBAs , where the server is sitting at 100% for prolonged periods. Check there are no other processes outside of SQL Server which are causing the server to be at 100%. Typically security scans, virus scans and monitoring can be root causes. I have also... Read more →