Welcome to MSDN Blogs Sign in | Join | Help

August 2009 - Posts

Thursday, August 27, 2009 3:16 PM

How to store performance monitor data into SQL Server using Reliability and Performance Monitor

Exactly what the title says. I spent some time on figuring this out since there is not so much information on this. Hopefully this will save you some time. What you need to do first is to create a System DSN to you SQL Server. Simply run odbcad32.exe
Posted by maspeng | 0 Comments
Thursday, August 27, 2009 9:03 AM

How to read a SQL Server trace file using .Net code, TraceFile and TraceServer.

When you wish to trace and see what is going on in SQL Server then the SQL Profiler tool is really useful. But what if you wish to read it from, for example, a C# console application? With or without having SQL Profiler installed. How do you do this?
Posted by maspeng | 0 Comments
Thursday, August 20, 2009 12:19 PM

"There is already an open DataReader associated with this Command which must be closed first" explained

Short one. This sometimes catches people out. When reading a SqlDataReader and then after the read is done, there is an attempt to use the connection that was used for the reading. The exception thrown is (in this case it is thrown when trying to update
Posted by maspeng | 0 Comments
Filed under: ,
Monday, August 17, 2009 10:13 AM

IsolationLevel is carried over to connections in connectionpool

When using SqlConnection and Transactions you my get a somewhat unexpected behavior. Namely that when you pick a connection from the connection pool, the connection you get will have inherited the IsolationLevel from what was set on the connection when
Posted by maspeng | 0 Comments
Filed under:
 
Page view tracker