AUTO_CLOSE and performance issue in a .NET application

One of the interesting scenario I worked recently. .NET application which has multiple tabs showing employee details shows poor performance when run for the first time during anytime of the day but when we connect to SQL Server Management Studio and run any ALTER COMMAND, then switch back to application, performance is as expected. This…

2

SQLSPIDAnalyzer.sql – My way of monitoring a particular request in SQL Server

Since a long time I wanted to leverage the details from the DMV dm_tran_database_transactions into my regular SPID monitoring script. I just tried it today and looks to be useful. Any feedbacks/bugs/thoughts, let me know. I’m combining sys.dm_os_workers, sys.dm_os_threads, sys.dm_exec_requests optionally  sys.dm_exec_query_plan, sys.dm_tran_locks to give a complete picture about a session currently running in SQL…

0

Best Performer: Distributed query (Four-part) or OPENQUERY when executing linked server queries in SQL Server

I wanted to share this information to all those who are searching for better performer when it comes to distributed query vs openquery for running linked server queries. Distributed Query : Linked server four part queries are also called distributed queries. Using distributed queries,  you can refer tables on different data sources/servers in a single…

6