Database

SQL Server Database Application performance issues?

• Are customers complaining your system is too slow?
• Are users complaining tasks take too long?
• Are some client applications running slowly or timing out?
• Are some queries/reports taking forever?

SQL Queries to Check Passwords & Privilege Assignments

SQL Server Locking & Blocking

I’m sure all of you who work with SQL Server systems will have experienced the frustration of trying to retrieve a set of records only to find that someone is updating/deleting/inserting one or more records that are matched by your query, and locks prevent you from accessing part or all of your record set.