Code:
/ Dotnetfx_Vista_SP2 / Dotnetfx_Vista_SP2 / 8.0.50727.4016 / DEVDIV / depot / DevDiv / releases / whidbey / NetFxQFE / ndp / fx / src / Data / System / Data / SqlClient / SqlStatistics.cs / 1 / SqlStatistics.cs
//------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //[....] //[....] //----------------------------------------------------------------------------- using System; using System.Collections; using System.Data.Common; using System.Diagnostics; namespace System.Data.SqlClient { internal sealed class SqlStatistics { static internal SqlStatistics StartTimer(SqlStatistics statistics) { if ((null != statistics) && !statistics.RequestExecutionTimer()) { // we're re-entrant -- don't bother. statistics = null; } return statistics; } static internal void StopTimer(SqlStatistics statistics) { if (null != statistics) { statistics.ReleaseAndUpdateExecutionTimer(); } } // internal values that are not exposed through properties internal long _closeTimestamp; internal long _openTimestamp; internal long _startExecutionTimestamp; internal long _startFetchTimestamp; internal long _startNetworkServerTimestamp; // internal values that are exposed through properties internal long _buffersReceived; internal long _buffersSent; internal long _bytesReceived; internal long _bytesSent; internal long _connectionTime; internal long _cursorOpens; internal long _executionTime; internal long _iduCount; internal long _iduRows; internal long _networkServerTime; internal long _preparedExecs; internal long _prepares; internal long _selectCount; internal long _selectRows; internal long _serverRoundtrips; internal long _sumResultSets; internal long _transactions; internal long _unpreparedExecs; // these flags are required if statistics is turned on/off in the middle of command execution private bool _waitForDoneAfterRow; private bool _waitForReply; internal bool WaitForDoneAfterRow { get { return _waitForDoneAfterRow; } set { _waitForDoneAfterRow = value; } } internal bool WaitForReply { get { return _waitForReply; } } internal SqlStatistics () { } internal void ContinueOnNewConnection() { _startExecutionTimestamp = 0; _startFetchTimestamp = 0; _waitForDoneAfterRow = false; _waitForReply = false; } internal IDictionary GetHashtable() { Hashtable ht = new Hashtable(); ht.Add("BuffersReceived", _buffersReceived); ht.Add("BuffersSent", _buffersSent); ht.Add("BytesReceived", _bytesReceived); ht.Add("BytesSent", _bytesSent); ht.Add("CursorOpens", _cursorOpens); ht.Add("IduCount", _iduCount); ht.Add("IduRows", _iduRows); ht.Add("PreparedExecs", _preparedExecs); ht.Add("Prepares", _prepares); ht.Add("SelectCount", _selectCount); ht.Add("SelectRows", _selectRows); ht.Add("ServerRoundtrips", _serverRoundtrips); ht.Add("SumResultSets", _sumResultSets); ht.Add("Transactions", _transactions); ht.Add("UnpreparedExecs", _unpreparedExecs); ht.Add ("ConnectionTime", ADP.TimerToMilliseconds(_connectionTime)); ht.Add ("ExecutionTime", ADP.TimerToMilliseconds(_executionTime)); ht.Add ("NetworkServerTime", ADP.TimerToMilliseconds(_networkServerTime)); return ht; } internal bool RequestExecutionTimer () { if (_startExecutionTimestamp == 0) { ADP.TimerCurrent(out _startExecutionTimestamp); return true; } return false; } internal void RequestNetworkServerTimer () { Debug.Assert(_startExecutionTimestamp!=0, "No network time expected outside execution period"); if (_startNetworkServerTimestamp == 0) { ADP.TimerCurrent(out _startNetworkServerTimestamp); } _waitForReply = true; } internal void ReleaseAndUpdateExecutionTimer () { long stopExecutionTimestamp; if (_startExecutionTimestamp > 0) { ADP.TimerCurrent(out stopExecutionTimestamp); _executionTime += (stopExecutionTimestamp - _startExecutionTimestamp); _startExecutionTimestamp = 0; } } internal void ReleaseAndUpdateNetworkServerTimer () { long stopNetworkServerTimestamp; if (_waitForReply && _startNetworkServerTimestamp > 0) { ADP.TimerCurrent(out stopNetworkServerTimestamp); _networkServerTime += (stopNetworkServerTimestamp - _startNetworkServerTimestamp); _startNetworkServerTimestamp = 0; } _waitForReply = false; } internal void Reset() { _buffersReceived = 0; _buffersSent = 0; _bytesReceived = 0; _bytesSent = 0; _connectionTime = 0; _cursorOpens = 0; _executionTime = 0; _iduCount = 0; _iduRows = 0; _networkServerTime = 0; _preparedExecs = 0; _prepares = 0; _selectCount = 0; _selectRows = 0; _serverRoundtrips = 0; _sumResultSets = 0; _transactions = 0; _unpreparedExecs = 0; _waitForDoneAfterRow = false; _waitForReply = false; _startExecutionTimestamp = 0; _startNetworkServerTimestamp = 0; } internal void SafeAdd (ref long value, long summand) { if (long.MaxValue - value > summand) { value += summand; } else { value = long.MaxValue; } } internal long SafeIncrement(ref long value) { if (value < long.MaxValue) value++; return value; } internal void UpdateStatistics() { // update connection time if (_closeTimestamp >= _openTimestamp) { SafeAdd(ref _connectionTime, _closeTimestamp - _openTimestamp); } else { _connectionTime = long.MaxValue; } } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. //------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //[....] //[....] //----------------------------------------------------------------------------- using System; using System.Collections; using System.Data.Common; using System.Diagnostics; namespace System.Data.SqlClient { internal sealed class SqlStatistics { static internal SqlStatistics StartTimer(SqlStatistics statistics) { if ((null != statistics) && !statistics.RequestExecutionTimer()) { // we're re-entrant -- don't bother. statistics = null; } return statistics; } static internal void StopTimer(SqlStatistics statistics) { if (null != statistics) { statistics.ReleaseAndUpdateExecutionTimer(); } } // internal values that are not exposed through properties internal long _closeTimestamp; internal long _openTimestamp; internal long _startExecutionTimestamp; internal long _startFetchTimestamp; internal long _startNetworkServerTimestamp; // internal values that are exposed through properties internal long _buffersReceived; internal long _buffersSent; internal long _bytesReceived; internal long _bytesSent; internal long _connectionTime; internal long _cursorOpens; internal long _executionTime; internal long _iduCount; internal long _iduRows; internal long _networkServerTime; internal long _preparedExecs; internal long _prepares; internal long _selectCount; internal long _selectRows; internal long _serverRoundtrips; internal long _sumResultSets; internal long _transactions; internal long _unpreparedExecs; // these flags are required if statistics is turned on/off in the middle of command execution private bool _waitForDoneAfterRow; private bool _waitForReply; internal bool WaitForDoneAfterRow { get { return _waitForDoneAfterRow; } set { _waitForDoneAfterRow = value; } } internal bool WaitForReply { get { return _waitForReply; } } internal SqlStatistics () { } internal void ContinueOnNewConnection() { _startExecutionTimestamp = 0; _startFetchTimestamp = 0; _waitForDoneAfterRow = false; _waitForReply = false; } internal IDictionary GetHashtable() { Hashtable ht = new Hashtable(); ht.Add("BuffersReceived", _buffersReceived); ht.Add("BuffersSent", _buffersSent); ht.Add("BytesReceived", _bytesReceived); ht.Add("BytesSent", _bytesSent); ht.Add("CursorOpens", _cursorOpens); ht.Add("IduCount", _iduCount); ht.Add("IduRows", _iduRows); ht.Add("PreparedExecs", _preparedExecs); ht.Add("Prepares", _prepares); ht.Add("SelectCount", _selectCount); ht.Add("SelectRows", _selectRows); ht.Add("ServerRoundtrips", _serverRoundtrips); ht.Add("SumResultSets", _sumResultSets); ht.Add("Transactions", _transactions); ht.Add("UnpreparedExecs", _unpreparedExecs); ht.Add ("ConnectionTime", ADP.TimerToMilliseconds(_connectionTime)); ht.Add ("ExecutionTime", ADP.TimerToMilliseconds(_executionTime)); ht.Add ("NetworkServerTime", ADP.TimerToMilliseconds(_networkServerTime)); return ht; } internal bool RequestExecutionTimer () { if (_startExecutionTimestamp == 0) { ADP.TimerCurrent(out _startExecutionTimestamp); return true; } return false; } internal void RequestNetworkServerTimer () { Debug.Assert(_startExecutionTimestamp!=0, "No network time expected outside execution period"); if (_startNetworkServerTimestamp == 0) { ADP.TimerCurrent(out _startNetworkServerTimestamp); } _waitForReply = true; } internal void ReleaseAndUpdateExecutionTimer () { long stopExecutionTimestamp; if (_startExecutionTimestamp > 0) { ADP.TimerCurrent(out stopExecutionTimestamp); _executionTime += (stopExecutionTimestamp - _startExecutionTimestamp); _startExecutionTimestamp = 0; } } internal void ReleaseAndUpdateNetworkServerTimer () { long stopNetworkServerTimestamp; if (_waitForReply && _startNetworkServerTimestamp > 0) { ADP.TimerCurrent(out stopNetworkServerTimestamp); _networkServerTime += (stopNetworkServerTimestamp - _startNetworkServerTimestamp); _startNetworkServerTimestamp = 0; } _waitForReply = false; } internal void Reset() { _buffersReceived = 0; _buffersSent = 0; _bytesReceived = 0; _bytesSent = 0; _connectionTime = 0; _cursorOpens = 0; _executionTime = 0; _iduCount = 0; _iduRows = 0; _networkServerTime = 0; _preparedExecs = 0; _prepares = 0; _selectCount = 0; _selectRows = 0; _serverRoundtrips = 0; _sumResultSets = 0; _transactions = 0; _unpreparedExecs = 0; _waitForDoneAfterRow = false; _waitForReply = false; _startExecutionTimestamp = 0; _startNetworkServerTimestamp = 0; } internal void SafeAdd (ref long value, long summand) { if (long.MaxValue - value > summand) { value += summand; } else { value = long.MaxValue; } } internal long SafeIncrement(ref long value) { if (value < long.MaxValue) value++; return value; } internal void UpdateStatistics() { // update connection time if (_closeTimestamp >= _openTimestamp) { SafeAdd(ref _connectionTime, _closeTimestamp - _openTimestamp); } else { _connectionTime = long.MaxValue; } } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007.
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- TextEditorTables.cs
- Directory.cs
- PageAdapter.cs
- StringFormat.cs
- UnaryOperationBinder.cs
- SafeNativeMethods.cs
- HijriCalendar.cs
- KerberosReceiverSecurityToken.cs
- SignatureToken.cs
- TypeName.cs
- IgnoreSection.cs
- OptimisticConcurrencyException.cs
- XamlInt32CollectionSerializer.cs
- NotifyIcon.cs
- BuildManager.cs
- updateconfighost.cs
- FilterableAttribute.cs
- DataRecordObjectView.cs
- ProtocolsSection.cs
- ImageDrawing.cs
- ElementProxy.cs
- DataGridViewColumn.cs
- VoiceSynthesis.cs
- Events.cs
- CriticalFileToken.cs
- HostedImpersonationContext.cs
- TypeGeneratedEventArgs.cs
- DataGridViewRowEventArgs.cs
- BaseConfigurationRecord.cs
- ProfileParameter.cs
- SecurityResources.cs
- ObjectNavigationPropertyMapping.cs
- AtomServiceDocumentSerializer.cs
- NativeMethods.cs
- SqlRowUpdatedEvent.cs
- CompressEmulationStream.cs
- CompilerScope.cs
- TextRangeBase.cs
- EntityDataSourceChangingEventArgs.cs
- NamespaceCollection.cs
- SecurityTokenReferenceStyle.cs
- CaseKeyBox.xaml.cs
- WorkflowElementDialog.cs
- PropertyItem.cs
- base64Transforms.cs
- ClientSession.cs
- OracleCommandSet.cs
- ShapingEngine.cs
- RelationshipFixer.cs
- Properties.cs
- IDispatchConstantAttribute.cs
- InvalidCastException.cs
- EnumBuilder.cs
- RepeatButton.cs
- DSASignatureFormatter.cs
- ColumnTypeConverter.cs
- WeakKeyDictionary.cs
- Point.cs
- ParameterCollection.cs
- AddInActivator.cs
- TypeUnloadedException.cs
- HtmlTernaryTree.cs
- ZipIOBlockManager.cs
- AssociatedControlConverter.cs
- NumberFormatter.cs
- PersonalizationProviderHelper.cs
- IdentityHolder.cs
- PrePostDescendentsWalker.cs
- Gdiplus.cs
- QilGenerator.cs
- WebPartPersonalization.cs
- RbTree.cs
- GridViewSelectEventArgs.cs
- FunctionOverloadResolver.cs
- RewritingValidator.cs
- ResourceIDHelper.cs
- Win32SafeHandles.cs
- ManagedWndProcTracker.cs
- CompiledQuery.cs
- FacetChecker.cs
- Fault.cs
- SimpleType.cs
- Button.cs
- IntegrationExceptionEventArgs.cs
- AuthenticationSection.cs
- Preprocessor.cs
- SiteMapDataSource.cs
- WebControl.cs
- ResourcesChangeInfo.cs
- CodeConstructor.cs
- GroupBoxRenderer.cs
- IPipelineRuntime.cs
- PolyQuadraticBezierSegmentFigureLogic.cs
- CompilerGeneratedAttribute.cs
- ProcessManager.cs
- NetStream.cs
- State.cs
- DesignerView.xaml.cs
- TextWriterEngine.cs
- XpsS0ValidatingLoader.cs