| Author |
Topic |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2010-03-26 : 13:04:27
|
| Hi whether Read,Write column in sqlserver 2000 profiler denotesin milliseconds or seconds? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
Posted - 2010-03-26 : 15:55:32
|
which column do i need to check for query optimization?quote:
Originally posted by tkizer
It's neither. What you are thinking about is the duration column, which is in milliseconds. It's not until 2005 that it changes. In 2005, the GUI displays it in milliseconds, but the data is actually in microseconds. So if you query the trace file or table, you get to see microseconds.Reads/writes have to do with I/O not time.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
|
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
Posted - 2010-03-26 : 16:10:42
|
for instance,if the Text Data is select queryCPU IS 90141READ IS 350232WRITE IS 1985DURATION IS 93656Which i need to considerSELECT abs(sum(Value)), V.VarID, getdate(), VarCurrency, @COBDate, sth.SourceIDFROM #a wrk INNER JOIN dbo.b V ON wrk.BusinessEntityShortName = V.BusinessEntityShortName AND wrk.RiskMeasureShortDescr = V.RiskMeasureShortDescr AND wrk.RiskIdShortName=V.RiskIdShortName AND isnull(wrk.CurveRefShortDescr,'')=isnull(V.CurveRefShortDescr,'') AND isnull(wrk.TimeBucketDays,'')=isnull(V.TimeBucketDays,'') INNER JOIN c sth ON wrk.HierarchyID = sth.HierarchyID INNER JOIN d st ON sth.SourceTableID = st.SourceTableIDWHERE st.Name = 'IR_Risk_XGRK_Limit' AND sth.AdjustLevelID = @BaseLevelID AND st.SourceSystemID=@SourceSystemIDGROUP BY V.VarID, VarCurrency,sth.SourceID quote:
Originally posted by tkizer
I look at TextData, Reads, Writes, CPU, and Duration.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Read column in profiler