MSSQLWIKI

• Karthick P.K

  

• Categories

  • 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

• Archives

  • 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 CreateFile Debugging error 17883 non yielding Error: 15466 External dump process returned no errors External dump process returned no errors.DoMiniDump () encountered error LockPagesinMemory MapUserPhysicalPages max server memory memory dump non-yielding Non-yielding IOCP Listener Non-yielding Scheduler Overlapped I/O OVERLAPPED structure Performance Process 0:0:0 ( ) Worker appears to be non-yielding on Scheduler Query tuning Severity: 16 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 sql server performance SQLServer Tools SSMS Stack Dump State: 1. UMS VirtualAlloc

• Facebook

• Do you have a question in SQL Server or stuck in SQL Server issue: Join our facebook group and post your questions to SQL Server experts

• SQL Server 2012

  • SQL SERVER 2012 is now available.Get SQL Server 2012 RTM/Trial and SQL Server 2012 Express

• Email Subscription

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

  Join 1,581 other followers

• 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

• feedburner email subscription

  Subscribe to MSSQLWIKI by Email

• Subscribe

  • Entries (RSS)
  • Comments (RSS)

• Visits

  

• SQL Server Blogs

  • 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
  • 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?
  • Linked server connection fails with “An error occurred during decryption”
  • SQL Saturday #116 : Don’t miss it
  • How to Create process in c++….. CreateProcess function
  • My “c:\” Drive gets full when I open the profiler trace
  • System stored procedures like sp_addsrvrolemember or sp_addserver may fail because of McAfee Host Intrusion Prevention
  • how to Open CreateFile (Createfile example)
  • Beyond XP_READERRORLOG (Parameters of XP_READERRORLOG)
  • A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_PowerShell_Engine_CNS,SQL_PowerShell_Tools_ANS]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed.
  • How to get the current state of cluster resource?
  • Script to free cache

• Author

  Karthick P.K

• Other SQL blogs

  • Sudarshan's SQL Server blog

• SQLSERVERSCRIBBLES.COM

  • Capture context switches from dm_os_ring_buffers May 15, 2013
  • SSIS package fails when executed as job using proxy account May 7, 2013
  • How to stimulate a SQL Server resource failure in cluster April 26, 2013
  • Error 601 : Could not continue scan with NOLOCK due to data movement. April 15, 2013
  • SQL Server monitoring March 28, 2013
  • Removing database mirroring March 21, 2013
  • SQLServer LooksAlive and IsAlive Check March 18, 2013
  • Builtin\Administrators cannot login in to SQL Server March 17, 2013
  • SQL Server assert in Location: purecall.cpp:51 March 7, 2013
  • Trace waits in SQLServer (SQLTRACE_BUFFER_FLUSH,TRACEWRITE,SQLTRACE_WAIT_ENTRIES,SQLTRACE_LOCK) March 4, 2013
  • How to view the Space used by each table in database March 1, 2013
  • FILESTREAM feature is disabled February 26, 2013
  • Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. February 18, 2013
  • XP_readerrorlog fails with Failed to open loopback connection. February 18, 2013
  • TCP Provider: The semaphore timeout period has expired February 15, 2013
  • Unable to connect to Microsoft Distributed Transaction Coordinator (MS DTC) to check the completion status of transaction. February 14, 2013
  • SQL Server integration services fails to start. February 13, 2013
  • Query to find SQL Server CPU utilization 2012. February 13, 2013
  • How to view xml plan as graphical execution plan February 13, 2013
  • Top queries by total I/O and average I/O in SQL Server February 12, 2013

 SELECT getdate() as "RunTime", st.text, qp.query_plan, a.* FROM sys.dm_exec_requests a CROSS APPLY sys.dm_exec_sql_text(a.sql_handle) as st CROSS APPLY sys.dm_exec_query_plan(a.plan_handle) as qp order by CPU_time desc  

One Response to “How to get SQL Text and Query Plan for statements which are executing now”

1. 

   then visit Emmanuel Adegbola to find the best advice on cheap mlm lead for you. cheap mlm lead said

   April 20, 2013 at 9:04 AM

   Hey there are using WordPress for your blog platform?

   I’m new to the blog world but I’m trying to get started and set up my own.
   Do you need any html coding expertise to make your own blog?
   Any help would be really appreciated!

   Reply

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

Notify me of follow-up comments via email.

Notify me of new posts via email.