|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
how to determine how many milliseconds a segment of code takes to execute in TSQL on sql server 2005how to determine how many milliseconds a segment of code takes to execute in
TSQL on sql server 2005? DR (softwareengineer98***@yahoo.com) writes:
> how to determine how many milliseconds a segment of code takes to You can use Profiler or a server side trace, which permits your collect> execute in TSQL on sql server 2005? duration on microsecond level. Just beware than in Profiler there is an option on whether to display duration in microseconds or milliseconds, and milliseconds is the default. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx Answered in .programming and the other groups where this was posted.
Show quote "DR" <softwareengineer98***@yahoo.com> wrote in message news:%23OCFcrAHIHA.5544@TK2MSFTNGP02.phx.gbl... > how to determine how many milliseconds a segment of code takes to execute > in TSQL on sql server 2005? >  |
|||||||||||||||||||||||
Other interesting topics