#USING CLIENT BASE STATISTICS 64 BITS#All of the counters for provider statistics use the common language runtime Int64 type ( long in C# and Visual Basic), which is 64 bits wide. The number of items available can be accessed via the Count property of the IDictionary interface reference returned by RetrieveStatistics. Statistical Values AvailableĬurrently there are 18 different items available from the Microsoft SQL Server provider. All statistical values gathered are on a per-connection basis. If you enable statistics, run your application for a while, and then disable statistics, the values retrieved will reflect the values collected up to the point where statistics were disabled. In addition, if RetrieveStatistics is called without StatisticsEnabled having been called first, the values retrieved are the initial values for each entry. If statistic gathering has not been enabled, an exception is not generated. At any time, you can call the ResetStatistics method of the SqlConnection object to reset the counters. You enumerate through the list as a set of name/value pair dictionary entries. After statistics are enabled, you can review them as a "snapshot in time" by retrieving an IDictionary reference via the RetrieveStatistics method of the SqlConnection object. You must enable statistics by setting the StatisticsEnabled property of the SqlConnection object to True after you have a valid connection object created. NET Framework Data Provider for SQL Server supports run-time statistics.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |