[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL 2005

Posted on 2009-02-23
7
Medium Priority
?
235 Views
Last Modified: 2012-05-06
Can some one tell me what is the unit of mesurement for the below
Duration is in macroseconds in SQL 2005
CPU  ?
READS ?
WRITE ?
0
Comment
Question by:Abeokuta
  • 5
  • 2
7 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 23709825
CPU: seconds
Reads/Writes: unit = 1 data block (of 8K)
0
 

Author Comment

by:Abeokuta
ID: 23709891
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
 

Author Comment

by:Abeokuta
ID: 23709895
How do I calcualte average read or write say read is 1000 and write is 1000
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 

Author Comment

by:Abeokuta
ID: 23709957
What about MEMORY
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 375 total points
ID: 23710051
>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
 

Author Comment

by:Abeokuta
ID: 23793415
Good
0
 

Author Comment

by:Abeokuta
ID: 23793418
Good
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question