We have a monitoring tool that tells us when a backup fails. This only works if the agent is running. If the agent isn’t running, then you don’t get an email that a job failed since the job didn’t run, and the monitoring tool doesn’t…
Category: sql server administration
I was approached by some developers that wanted to benchmark performance on a development server. Good for them thinking ahead before it’s in production potentially ruining performance. Instead of using an Idera Diagnostic Manager licence, which means taking one away from a production server to…
https://www.brentozar.com/archive/2016/01/cheat-sheet-how-to-configure-tempdb-for-microsoft-sql-server/ 1 volume for all tempdb files Use SSDs 8 equally sized files Size them and log file to fill up the tempdb drive
There’s a really good guide on installing and setting up AG by Brent Ozar, but if you want to setup a multi subnet failover cluster, you will need a lot of ports opened up so that your AG will actually work. Port number Between Reason…
good to do b/c the bigger it is, the longer it will take to load into memory — USE msdb; GO EXEC sp_cycle_agent_errorlog;
Very detailed https://www.brentozar.com/?s=What+to+Do+When+DBCC+CHECKDB+Reports+Corruption
https://www.simple-talk.com/sql/sql-tools/sql-server-tablediff-utility/ “TableDiff can be used for comparing tables, as when you run automated tests that check a result against a table of expected values.”
Excerpt from http://www.sqlsoldier.com/wp/sqlserver/schemaonlybackupsandrestores Schema-only Backups Alternatively, there is an option for exporting a data-tier application which has lots of options and allows you to export only part of a database and includes the data. That’s a discussion for another day.If you right-click on a database…
https://www.red-gate.com/simple-talk/sql/performance/the-default-trace-in-sql-server-the-power-of-performance-and-security-auditing/ –enabling default trace sp_configure ‘show advanced options’, 1; GO RECONFIGURE; GO sp_configure ‘default trace enabled’, 1; GO RECONFIGURE; GO –querying default trace SELECT * FROM sys.fn_trace_gettable(CONVERT(VARCHAR(150), ( SELECT TOP 1 f.[value] FROM sys.fn_trace_getinfo(NULL) f WHERE f.property = 2 )), DEFAULT) T JOIN sys.trace_events TE…
SELECT dest.text FROM sys.dm_exec_query_stats AS deqs CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest WHERE deqs.last_execution_time > ’12/28/15 11:00′ AND dest.text LIKE ‘%DROP%’;