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
Review your Windows task scheduler: It can impact your SQL Server performance
Category: Performance Item: Windows task scheduler What is the windows task scheduler? It is a Windows component that can schedule programs and programs to run at
Take care with dangerous SQL Server builds
Category: Reliability Item: Dangerous build of SQL Server Why should you care about your build version of SQL Server? There are known bugs and threats in specific
Disabling Windows automatic updates
Category: Reliability Item: OS Updates settings Why should you care about them? Windows updates are set to a non-optimal setting. Updates can start downloading at
How can you find the SQL Server jobs that start simultaneously?
Category: Performance Item: SQL Agent jobs starting simultaneously. Why should you care about them? Multiple SQL Server Agent jobs are configured to start simultaneously, which will not
Finding user tables in SQL Server system databases
Category: Reliability Item: User tables in sys DBs Why should you care about them? User datatables should not be in the system databases (master, msdb). In case
When was the last time your SQL Server wait stats was cleared?
Category: Performance Item: Wait statistics What are SQL Server wait statistics? They are data about all the waits encountered by SQL Server threads at the instance level.
Finding heap tables in your SQL Server database
Category: Performance Item: Active tables without clustered IX What is a Heap in SQL Server table? A table without a clustered index is called Heap. It consists
Are your SQL Server generating dump files?
Category: Reliability Item: SQL Server memory dumps What are the SQL Server dump files? They are memory dumps files generated when SQL hits a bug, or something
How many CPUs are your SQL Server able to use?
Category: Performance Item: CPU schedulers offline What is a CPU Scheduler in SQL Server? A query that you want to execute represents a task, your work. The
Why should you care about the database compatibility level in SQL Server?
What is the database compatibility level? A compatibility level is an option associated with each database. It controls some database behaviors to be compatible with a particular version
Why should you care about CLR integration in SQL Server?
What is the CLR integration on SQL Server? Included in SQL Server 2005, the CLR is the heart of the Microsoft .NET framework. The common
Best practices to keep your SQL Server backups safe
Did somebody drop a database in production instead of development? Did you run the wrong DELETE statement? Let’s follow these best practices and recommendations for