On any given production environment a SQL DBA must follow set of best practices to ensure smooth and highly optimized databases availability. Here are few common mistakes that I have identified and would recommend to fix if you have encountered or seeing anything similar. 1. Not preparing and validating a reliable backup and recovery policy [...]
Posts Tagged ‘SQL profiler’
What are the common SQL DBA mistakes?
Posted: 21st March 2011 by Deepak in SQL BI/DW/SSRS, SQL DBA, SQL DevTags: backup and recovery, common dba mistakes, deepak kumar sql dba, sql dba mistakes, SQL DR Solution, sql proactive monitoring, SQL profiler, sql service pack
3
Automate SQL Server Profiler Trace Execution
Posted: 12th January 2011 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: performance tuning, proactive dba, profiler trace, query, sp_trace_setevent, sp_trace_setstatus, SQL profiler, sql trace, T-SQL
SQL profiler is an excellent tool for T-SQL query performance optimization. SQL Server Production DBA’s use Profiler to scan what T-SQL queries are getting executed inside SQL Server and what are the queries that can be filtered for further fine-tuning. SQL profiler has inbuilt scheduler for stopping a trace, but Trace Properties does not provide [...]
