MSSQLWIKI

• Karthick P.K

  

• Categories

  • Always On
  • Backup/Restore
  • Configuration
  • Connectivity
  • Copy database wizard
  • Database mail
  • DBCC
  • Debugging
  • DTS/SSIS
  • Memory
  • Optimizer
  • Performance
  • Programming
  • Recovery
  • Replication
  • Security
  • Space management
  • SQL Cluster Setup
  • SQL General
  • SQL Query
  • SQL Saturday
  • SQL Server Cluster
  • SQL Server Engine
  • SQL Server I/O
  • SQL Server memory
  • SQL Server Setup
  • SQL Server Tools
  • SQLServer SOS
  • SSMS
  • Startup failures
  • Summary

• Archives

  • October 2020
  • January 2014
  • December 2013
  • November 2013
  • September 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • July 2011
  • June 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009

• Tags

  17883 17884 17887 17888 AllocateUserPhysicalPages AWE Allocator API's Blocking Connectivity CreateFile CreateMemoryResourceNotification Debugging Encrytion error 17883 non yielding Error: 15466 External dump process returned no errors External dump process returned no errors.DoMiniDump () encountered error GetClusterResourceState GetPerformanceInfo GetProcessMemoryInfo GetVolumeInformation Index usage Inside SQLOS Level 16 Linked server LockPagesinMemory LookupPrivilegeValue MapUserPhysicalPages max server memory memory dump memory leak non-yielding Non-yielding IOCP Listener Non-yielding Scheduler OpenCluster OpenClusterResource OpenProcess OSVERSIONINFOEX Overlapped I/O OVERLAPPED structure Performance Process 0:0:0 ( ) Worker appears to be non-yielding on Scheduler Profiler QueryMemoryResourceNotification Query tuning Replication Severity: 16 SOS SQL General SQLOS SQL Query sql scheduler SQL Server 2005 SQL Server 2008 SQLServer Cluster SQLServer CPU SQLServer dump SQL Server management studio sql server maximum server memory SQLServer mdmp sqlserver memory SQL Server memory SQLServer operating system sql server performance SQLServer scheduler SQLServer SOS SQLServer Tools SSMS Stack Dump State: 1. Trace Transactional replication UMS User mode sceduler VirtualAlloc What is SQLSOS?

• Facebook

  Facebook

• Twitter

  Tweets by MSSQLWIKI

• Do you have a question in SQL Server or stuck in SQL Server issue? Click here to join our facebook group and post your questions to SQL Server experts

• Email Subscription

  Enter your email address to subscribe to this blog and receive notifications of new posts by email.

  Email Address:

  Sign me up!

  Join 9,950 other subscribers

• SQLWiki

  • Programming
  • SQL Server Blogs
  • SQL Wiki
    • SQL Server Cluster
      • Known issues: SQL Server Cluster and standalone Setup
    • SQL Server Agent
      • SQL Agent MaxWorkerThreads and Agent subsystem
    • SQL Performance
      • Address Windowing Extensions
      • ASYNC_NETWORK_IO or NETWORK_IO
      • Lock pages in memory
      • Windows 2008 and Windows 2008 R2 Known issues related to working set /Memory
      • Basics of SQL Server Memory Architecture
      • SQL Server I/O Bottlenecks
      • Troubleshooting SQL Server Memory
  • Disclaimer

• Subscribe

  • Entries (RSS)
  • Comments (RSS)

• feedburner email subscription

  Subscribe to MSSQLWIKI by Email

• Visits

  

• SQL Server Blogs

  • Running 1 Million databases on Azure SQL
  • Top SQL Server blogs from MSSQLWIKI
  • SQL Server connectivity, Kerberos authentication and SQL Server SPN (Service Principal Name for SQL Server)
  • Transactional Replication Part -2
  • Transactional Replication Part -1
  • Tempdb latch contention
  • Troubleshooting Transactional replication Latency using Agent Statistics
  • The connection to the primary replica is not active. The command cannot be processed
  • False warning “A significant part of sql server process memory has been paged out”
  • What does MemoryUtilization in sys.dm_os_ring_buffers and Memory_utilization_percentage in sys.dm_os_process_memory represents?
  • SQL Server monitor
  • Max server memory – Do I need to configure?
  • SQL Server and VMware ballooning
  • Inside sys.dm_os_ring_buffers
  • SQL Server lock pages in memory
  • SQL Server -g
  • SQL Server Operating system (SOS) – Series 3
  • SQL Server Operating system (SOS) – Series 2
  • SQL Server Operating system (SOS) – Series 1
  • SQL Server fails to start with error "Failed allocate pages: FAIL_PAGE_ALLOCATION 1" During startup
  • Debugging memory Leaks using Debug diagnostic tool.
  • SQL Server memory leak
  • SQL Server NUMA load distribution
  • SQL Server Query optimization
  • SQL Server 2012 Memory
  • SQL Server Exception , EXCEPTION_ACCESS_VIOLATION and SQL Server Assertion
  • What is RESOURCE_SEMAPHORE_QUERY_COMPILE?
  • SQL Server Parameter sniffing
  • Optimizer Timeout or Optimizer memory abort
  • Troubleshooting SQL Server high CPU usage
  • SQL Server Latch & Debugging latch time out
  • SQL Server: Ghost records
  • I/O requests taking longer than 15 seconds to complete on file
  • Database Mail errors in SQL Server (Troubleshooting steps)
  • Non-yielding IOCP Listener, Non-yielding Scheduler and non-yielding resource monitor known issues and fixes
  • How to analyze Non-Yielding scheduler or Non-yielding IOCP Listener dumps ……
  • SQL Server generated Access Violation dumps while accessing oracle linked servers.
  • Service pack ,Hotfix and CU installation for SQL Server 2005 might fail with “Unable to install Windows Installer MSI file“
  • A significant part of SQL Server process memory has been paged out
  • What is Target Server Memory (KB)?
  • SQL Server performance degraded in 32-Bit SQL Server after adding additional RAM.
  • Transaction log for the database is growing and system SPID is holding open transaction
  • Copy database wizard or replication setup might fail due to broken dependency
  • SQL Server Agent is taking long time to start
  • (SQLServer) Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893802.
  • Multi Threaded OVELAPPED and Nonbuffered I/O Example
  • Asynchronous I/O example
  • SQL-Server resource fails to come online IS Alive check fails
  • The backup of the file or filegroup "" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.
  • How to move the LOB data from one file group to other?

• Author

  Karthick P.K

• Other SQL blogs

  • Sudarshan's SQL Server blog

• SQLSERVERSCRIBBLES.COM

  • Integration Services server cannot be configured because there are active operations. Wait until there are no active operations, and then try to configure the server again
  • SQL Server setup fails with “Failed to retrieve data for this request”
  • The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication.
  • Sp_rename fails : Either the parameter @objname is ambiguous or the claimed @objtype (object) is wrong.
  • SSIS package fails with out of memory errors
  • Cannot bring the Windows Server Failover Clustering (WSFC) resource (ID ‘ ‘) online (Error code 5018).
  • SQL Server cluster installation checklist
  • PREEMPTIVE_OS_AUTHORIZATIONOPS waits in SQL Server
  • SQL Server Backup compression
  • Types of isolation levels in SQL Server

SELECT

    *

 FROM sys.dm_exec_cached_plans cp

  CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) eqp

  CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) est

 --WHERE   est.dbid = DB_ID('DBNMAE')

One Response to “Script to get all the Query and cached plans”

1. 

   Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said

   January 11, 2014 at 12:57 PM

   […] Script to get all the Query and cached plans […]

   Reply