Skip to content

SQL Canada (SQLCAN)

Data – Analytics – AI – Random Thoughts

Home
SQLOpDB
DBA Queries
Acclaim Badges
About

Month: October 2011

Finding All Plans/SQL Statements that executed in Parallel

October 21, 2011 Mohit

References: #21 Statement copied from The Rambling DBA: Jonathan Kehayias Blog

Continue reading

Rate this:

Get Top 50 SQL Statements/Query Plans

October 21, 2011 Mohit

Finding out what statements causing grief on SQL Server has become significantly easier with SQL Server 2005+. I am using some of the DMV/DMF to

Continue reading

Rate this:

Contact Me

mohitkgupta@msn.com

Contact me if you need assistance with PTO, HADR, Automation, etc. :)

Search for:

Categories

Administration (44)
- SQLOpDB (13)
Announcement (17)
Azure (1)
- Azure Storage (1)
Best Practices (3)
Database Mirroring (5)
Disaster Recovery (5)
Documentation (1)
Dynamic Management Views/Functions (11)
Full Text Search (2)
High Availability and Disaster Recovery (18)
- AlwaysOn Availability Groups (3)
- Cluster Errors (1)
- SQL Failover Cluster (2)
- Windows 2003 Clustering (3)
- Windows 2008 Clustering (9)
- Windows 2008 R2 Clustering (3)
Interesting Reads (11)
Maintenance Plans (2)
Operating System Errors (2)
Performance Tuning (21)
Published Article (2)
Reporting (7)
- Power BI (2)
- Power BI Desktop (2)
- Report Builder (1)
- SSRS 2000 (1)
- SSRS 2008 (1)
Security (10)
Smart Index Management (3)
SQL 2000 (5)
SQL 2005 (29)
SQL 2008 (18)
SQL 2008 R2 (11)
SQL 2012 (16)
SQL 2014 (11)
SQL 2016 (15)
SQL Bootstrap Errors (1)
SQL Embedded Edition (1)
SQL Errors (15)
SQL Internals (2)
SQL Protocols (1)
SQL Replication Errors (1)
SQL Server Tools (1)
- SQL Server Configuration Manager (1)
T-SQL Reference (4)
Tinkering (1)
Tools (14)
Troubleshooting (30)
Windows 2008 (1)
Windows 2008 R2 (2)

Tags

ApexSQL Tools Authentication Automation Capacity Planning Central Management Server CMS Computed Columns Configuration Health CTE CTP Database Corruption DBA Queries DBCC CHECKDB Distributed Transactions DMF - sys.dm_exec_query_plan DMF - sys.dm_exec_sql_text DMF - sys.dm_io_virtual_file_stats DMV - sys.dm_exec_query_stats DMV - sys.dm_exec_requests DMV - sys.dm_os_waiting_tasks fn_dblog Hekaton in-doubt xact resolution In-Memory OLTP Index Management Jan 2019 Update KB Articles Kerberos Lazy Writer Linked Servers Maintenance Plans Microsoft Forever Modeling mofcomp M Query Language Multi-Server Management Named Pipes Non-Technical NUMA Configuration OBJECT_NAME Operating System Error 5 PAL perfmon Performance Counters Permissions Power Query Language PowerShell Presentation Processor Imbalance References Security Service Principal Names (SETSPN) Slicer Pane Smart Guides SQL Error 5172 SQL Error 18456 SQLOpDB Reports SQLOpsDB Reports SQLPASS SQL Patches & Hotfixes SQL Server Disaster Recovery SSIS SSMS SSMS 2008 SSPI Error SSRS Suspect Database Syntax Highlight sys.database_mirroring_endpoints sys.dm_tran_active_transactions sys.indexes sys.tables sys.tcp_endpoints Undocumented Functions Wait Types

Archives

Archives

Administration Links

Create account
Log in
Entries feed
Comments feed
WordPress.com

Blog Stats

159,408 hits

Website Powered by WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Subscribe Subscribed
- SQL Canada (SQLCAN)
- Already have a WordPress.com account? Log in now.