Browse by Tags

TSQL to list the most used query plans

Published 28 September 7 3:12 AM | SSQA.net

select TOP 100 objtype, p.size_in_bytes, LEFT([sql].[text], 100) as [text] from sys.dm_exec_cached_plans p outer apply sys.dm_exec_sql_text (p.plan_handle) sql ORDER BY usecounts DESC...( read more ) Read More...

Filed under: sql server, query, plan, tsql, execution, cached

Your Disaster Recovery plan is only as good as the backup systems at its foundation?

Published 27 September 7 4:34 AM | SSQA.net

So how does your DR plan look like when it comes to reality? And you know the stats aren't pretty when it comes to business success rates after a disaster has hit. Make sure your data backup and DR plans are in check to avoid becoming a statistic...

Filed under: webcast, backup, integration, plan, disaster recovery, implementation, virtualization

FIX: In a maintenance plan, the databases that you selected are no longer selected when you edit a Back Up Database task in SQL Server 2005 Service Pack 2

Published 19 September 7 5:23 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, database, plan, kba, maintenance, service pack2, backups

FIX: Error message when you run a query that selects many columns and that joins many tables in SQL Server 2005 Service Pack 2: "The query processor could not produce a query plan"

Published 30 August 7 1:42 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, query, plan, kba, service pack2, processor

On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan

Published 23 August 7 3:15 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, integration, ssis, ssms, services, plan, kba, maintenance

What events will cause a flushing of plan in cache?

Published 14 May 7 7:17 AM | SqlServer-QA.net (SSQA)

We already know that using DBCC FREEPROCCACHE will have the affect of flushing all the cache with immediate affect and also DBCC FREESYSTEMCACHE (new in SQL 2005) has similar affect but will flush the plans asynchronously that are marked as unused anymore...

Filed under: sql server, management, memory, security, perfmance, plan, cache

Reset cached plan - how to and what to?

Published 14 May 7 3:53 AM | SqlServer-QA.net (SSQA)

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...

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

Cached query plans and top stored procedures that are recompiled

Published 11 May 7 6:2 AM | SqlServer-QA.net (SSQA)

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...

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