The Red9 Blog
Get our new tips before anyone else. Enter your email below to join our private list!
Most Popular Red9 Posts
Latest From Red9
Monitoring deadlocks in the SQL Server
What is Deadlock in SQL Server? A deadlock occurs when there is a cyclic dependency between two or more threads, or processes, for some set
Disable unnecessary SQL Server instances and services
Why should you care about services that are not needed? You may be wasting your precious resources on unused services. It would be best if
Are triggers making your SQL Server slow?
Trigger usage What are SQL Server triggers? They are a particular type of stored procedure that automatically runs when an event occurs in the database.
Removing offline databases and orphaned data files from your SQL Server
What are orphaned data files? Orphaned database files are files not associated with any attached database (live database). Sometimes when you drop a database from
Review your Windows Task Scheduler: It can impact your SQL Server performance
Windows task scheduler What is the windows task scheduler? It is a Windows component that can schedule programs and programs to run at pre-defined times
Dangerous SQL Server Builds
Dangerous builds of SQL Server Why should you care about your build version of SQL Server? There are known bugs and threats in specific build
Disabling Windows automatic updates
Windows OS Update Settings Why should you care about them? Windows updates are set to a non-optimal setting. Updates can start downloading at an unpredictable
How can you find the SQL Server jobs that start simultaneously?
SQL Agent jobs starting simultaneously. Why should you care about them? Multiple SQL Server Agent jobs are configured to start simultaneously, which will not perform
Finding user tables in SQL Server system databases
User tables in sys DBs Why should you care about them? User data tables should not be in the system databases (master, msdb). In case
When was the last time your SQL Server wait stats was cleared?
Wait statistics What are SQL Server wait statistics? They are data about all the waits encountered by SQL Server threads at the instance level. Using
Finding heap tables in your SQL Server database
Active tables without clustered indexes What is a Heap in SQL Server table? A table without a clustered index is called Heap. It consists only
Is your SQL Server generating dump files?
What are the SQL Server memory dump files? They are memory dumps files generated when SQL hits a bug, or something “unexpected” happens. This same