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 ?
AbeokutaAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>is it millisec or macro in sql 2005 is it 1000000
sorry, milliseconds.

there is not such thing than "macro" seconds...


>Can you expalin further please
>Reads/Writes: unit = 1 data block (of 8K)

every database read does a read of entire blocks from the files (or the memory, if the relevant block is already in memory).
so, 1 logical read get 8KB of data, while the block might not be 100% full.


>How do I calcualte average read or write say read is 1000 and write is 1000
can you explain, please?

>What about MEMORY
what do you mean, with "memory", please?

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
CPU: seconds
Reads/Writes: unit = 1 data block (of 8K)
0
 
AbeokutaAuthor Commented:
is it millisec or macro in sql 2005 is it 1000000

Can you expalin further please
Reads/Writes: unit = 1 data block (of 8K)
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
AbeokutaAuthor Commented:
How do I calcualte average read or write say read is 1000 and write is 1000
0
 
AbeokutaAuthor Commented:
What about MEMORY
0
 
AbeokutaAuthor Commented:
Good
0
 
AbeokutaAuthor Commented:
Good
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.