Ways to troubleshoot performance problems in SQL Server

Ways to troubleshoot performance problems in SQL Server.

SET SHOWPLAN_ALL ON
SET SHOWPLAN_TEXT ON
SET STATISTICS IO ON
SQL Server Profiler
Windows NT /2000 Performance monitor
Graphical execution plan in Query Analyzer
Steps to secure an SQL Server
Use NT authentication. Use server database and application roles to control access to the data. Secure the physical database files using NTFS permissions.......
What is a deadlock and what is a live lock?
When two processes, each having a lock on one piece of data, attempt to acquire a lock on the other's piece........
What is blocking?
When one connection from an application holds a lock and a second connection requires.......
Post your comment

Related Content

Follow us

▲