Link to home
Start Free TrialLog in
Avatar of Abeokuta
Abeokuta

asked on

SQL 2005

Can some one tell me what is the unit of mesurement for the below
Duration is in macroseconds in SQL 2005
CPU  ?
READS ?
WRITE ?
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

CPU: seconds
Reads/Writes: unit = 1 data block (of 8K)
Avatar of Abeokuta
Abeokuta

ASKER

is it millisec or macro in sql 2005 is it 1000000

Can you expalin further please
Reads/Writes: unit = 1 data block (of 8K)
How do I calcualte average read or write say read is 1000 and write is 1000
What about MEMORY
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Good
Good