Simple Recovery changes recovery options before it changes a performance diagnosis. I choose it from the agreed recovery requirements.
Recovery Model Insert Test: FULL vs SIMPLE Under Load
A recovery model insert test compares FULL and SIMPLE under a load of 16 connections. The log written is almost the same in both, and the elapsed time depends more on the server than on the model. The real difference is when the log can be reused, and this post shows that step by step.
How to Get Details of All Files Associated with Database from MDF? – Interview Question of the Week #275
Question: How to Get Details of All files Associated with Database from MDF? Let us learn about the DBCC command DBCC command dbcc checkprimaryfile.
Insert Workload Waits: WRITELOG and PAGELATCH_EX
Insert workload waits come down to two names, WRITELOG and PAGELATCH_EX. This post runs 16 connections that insert one row at a time and reads their waits with a tested script. It explains what each wait means and where to look for a fix.
Msg 17177 in the SQL Server Error Log: What It Means
Msg 17177 is an informational line in the SQL Server error log that reports the process ID of the instance. This post explains its two forms, a daily line and a start-up line, and reads both with a short query. It also shows how the line reveals uptime, downtime and the time zone of the server.
Additional Logging for SQL Server Agent: Three Methods
Additional logging for SQL Server Agent means raising the Agent error log level, so the Agent writes more lines about its own work. This post reads the current level, changes it with T-SQL and restores it in the same script, and shows the Management Studio and registry routes.
SQL SERVER – Always On Listener Failure – Provisioning Computer Object Failed With Error 5
I have written a few blogs on issues about the failure of listener creation in the cluster. In this blog, we will explore listener creation failure.