Browse by Tags

• best practice
• dmv
• management
• monitoring
• perfmon
• profiler
• public
• security
• server state
• sql server
• stats
• users
• view

SQL Server 2005: Deny Server-Level Dynamic Management Views to public group
21 December 07 06:47 AM | SQL Master | 2 Comments   

As you are aware DMV - Dynamic management views are very good to provide server-level information and some of them with detailed information on the execution environment of the database engine. Just to introduce about DMVs, there are two types of dynamic Read More...

Filed under: performance, sql server, security, package, dmv, users, view, best practice, monitoring, public, server state

Have you looked at SQL Server Managment Pack?
05 June 07 08:29 AM | SQL Master | 1 Comments   

SQL Server Management Pack, this is a good snippet to monitor the availablity and performance of SQL Server 2000 and 2005. This tool has also got ability to issue alerts for configuration problems. The Management Pack discovers Database Engines, Database Read More...

Filed under: performance, sql server, management, package

Stored procedures performance issues
08 May 07 03:57 AM | SQL Master | 0 Comments   

Every now and then I tend to see lot of questions such as "We have a web application which interacts with SQL Server through Stored Procs. Every so often it seems the response time for an individual Stored Proc will go from a few seconds to a few minutes. Read More...

Filed under: performance, sql server, stats, package, perfmon, profiler