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
Azure SQL: How to choose the right service database
What is Azure SQL? In the recent past, Microsoft introduced Azure SQL, bringing all the SQL Server products in one suite. Microsoft is grouping all
SQL Performance Tuning Report – 589x faster!
Case study #16 Here is another recent SQL Server performance tuning report. The stored procedure below was one of the most called on the client’s
SQL Performance Tuning Report – 3,187% gain!
Real sample #15 Here is another recent SQL Server performance tuning report. Improvements achieved CPU from 125 to 18 Reads from 21,737 to 18,411 Duration
SQL Performance Tuning Report – 13x Faster!
Today I am sharing another MS SQL Performance tuning report from recent tuning. Improvements after Red9 SQL Server tuning After making a couple of small
SQL Server objects created with SET Options
Category: Performance Item: Objects created with SET Options What are the set options? SQL Server backward compatibility SET options allow legacy T-SQL code to run
Are you using stored procedures with recompile option?
Category: Performance Item: SPs with RECOMPILE What is the RECOMPILE option? The compilation is the process when a query execution plan of a stored procedure
Should you care about page life expectancy in the SQL Server?
Category: Performance Item: Page life expectancy What is the SQL Page Life Expectancy (PLE)? PLE is the expected time (in seconds) that a data file page read
Do not waste CPU to process implicit conversions in the SQL Server
Category: Performance Item: Implicit Conversion What is SQL Server implicit conversion? It occurs when SQL Server needs to convert the value of variables or columns to another
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 them? You may be wasting your precious resources on unused services. It would be best if you prioritize your more
Are the triggers degrading your SQL Server performance?
Category: Performance Item: Trigger usage What are SQL Server triggers? They are a particular type of stored procedure that automatically runs when an event occurs in the
Removing offline databases and orphaned datafiles from your SQL Server
What are orphaned datafiles? Orphaned database files are files not associated with any attached database (live database). Sometimes when you drop a database from a