Execution Plans and IO Statistics in SQL Server

		Wrox Programmer Forums > .NET > Other .NET > ADO.NET
Execution Plans and IO Statistics in SQL Server

ADO.NET For discussion about ADO.NET.Â Â Topics such as question regarding the System.Data namespace are appropriate.Â Â Questions specific to a particular application should be posted in a forum specific to the application .

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

March 19th, 2004, 10:40 AM

bmains

Friend of Wrox

Join Date: Jun 2003

Posts: 1,998

Thanks: 0

Thanked 3 Times in 3 Posts

Execution Plans and IO Statistics in SQL Server

Hello,

I want to be able to access the execution plans and IO statistics programmatically in ADO.NET. In ADO it can't be done; I was wondering if there is a way to do it in ADO.NET's SQLConnection or SQLDataAdapter object maybe? What I need to do is give the IO statistics and execution plans to the DBA, and I have a lot of stored procedures (200+), and was wondering if there was a quicker way to do it.

Thanks,

Brian Mains

__________________
Brian

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Plans to merge 2 Access VBA forums	jminatel	Access VBA	17	August 22nd, 2014 12:51 PM
Unsuccessfuly execution of SQL statement in VBA	cindyzhou	Access VBA	0	January 1st, 2006 10:58 PM
Unsuccessful execution of SQL statement within VBA	cindyzhou	Pro VB Databases	0	January 1st, 2006 10:55 PM
How to interprete Execution plans for queries	pallavijyo	SQL Server 2000	1	December 17th, 2004 06:49 AM
Execution Plans and IO Statistics	bmains	SQL Server 2000	0	March 19th, 2004 10:39 AM