Browse by Tags

• best practice
• cache
• component
• databases
• dmv
• indexes
• integration
• management
• memory
• monitoring
• perfmon
• performance
• plan
• profiler
• public
• query
• requirement
• rowcount
• security
• server
• server state
• sp
• ssis
• stats
• table
• 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

How to get rowcount efficiently within a SSIS package?
05 September 07 01:50 AM | SQL Master | 2 Comments   

I would like to call this as how efficiently you can obtain counting rows in SSIS package. Usual thought would come is @@rowcount or COUNT_BIG functions, but this is not that efficient way to obtain the results. SSIS provides the snippet within its components Read More...

Filed under: sql server, ssis, package, databases, table, rowcount, component, requirement

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

Reset cached plan - how to and what to?
14 May 07 01:53 AM | SQL Master | 1 Comments   

I don't believe you would need to reset the cache on a production server, it is not a best practice to perform in this case. Most of the times in development or test environments for the purpose of benchmarking you would need to reset the cache for optimum Read More...

Filed under: package, cache, memory, indexes, perfmance, sql server, plan, integration

Cached query plans and top stored procedures that are recompiled
11 May 07 04:02 AM | SQL Master | 4 Comments   

We all know that the cached query plans are good to go to attain the performance and no doubt that inefficient query plan will cause more distress to performance with an increased spike in CPU consumption. At the same occurrence of recompilation of a Read More...

Filed under: sql server, query, plan, package, cache, indexes, perfmance

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

Unable to continue SSIS package after SP2
27 April 07 06:21 AM | SQL Master | 0 Comments   

From time to time we manage our SSIS packages by modifying the configuration file to allow the execution even though the service is stopped. 2 of the packages were working perfectly until we have applied the Service Pack 2 for SQL 2005 couple of weeks Read More...

Filed under: sql server, server, integration, ssis, package, sp