Browse by Tags

• bad
• execution plan
• indexes
• long running
• memory
• notification
• object
• optimization
• performance
• security
• sql server
• statistics
• tsql
• update statistics

Usage and good practices with UPDATE STATISTICS feature in SQL 2005
23 July 07 03:39 AM | SQL Master | 1 Comments   

UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be Read More...

Filed under: performance, security, query, dmv, optimization, tsql, statistics, update statistics

Why query execution timeout happens and find queries that have granted memory or waiting on memory?
23 July 07 02:44 AM | SQL Master | 1 Comments   

Have you ever identified the reasons for why and how does a query execution timeout happens within your SQL Server environment. For the beginners I would like to explain that b efore executing a query, SQL Server estimates how much memory it needs to Read More...

Filed under: performance, sql server, query, dmv, memory, notification, execution plan, long running, bad

Get a blocking list for the objects & indexes using DMV
13 June 07 07:44 AM | SQL Master | 6 Comments   

Yet another help from DMV I would like to share here, say on a SQL Instance you are getting low-level I/O and blocking intermittently. For the I/O issues using SYSMON (PERFMON) is ideal to get more information during the busy times and low-usage times Read More...

Filed under: performance, sql server, query, dmv, indexes, object