Calculating COUNTER Physical Disk: AVG. DISK QUEUE LENGTH

Physical Vs. Logical Disk Queue Length
Does anyone have any recommendation on whether it's better to monitor the average queue lenght for physical or logical drives? What about for a RAID set?

Just wondering,

thanks

View Replies !

---

Avg Disk Queue Length
avg disk queue length is 100%. Any ideas?

=============================
http://www.sqlserverstudy.com

View Replies !

---

How To Calculate AVG. Disk Queue Length
Hi All,
    we have collected perfmon data for a specific lun.  Here is the background of the lun.  The lun is Raid10 with 4 physical disks.  We have problems interpreting the data. In the perfmon counter screen we have a max of 435 and average of 0.512.  Can somebody tell  us what is that we are missing?  Any help is greatly appreciated.
 
Thanks,
Venkat.

View Replies !

---

PROBLEM: Sporadic Spikes In Avg. Disk Queue Length - PLEASE HELP
PROBLEM: Sporadic spikes in Avg. Disk Queue Length with users freezing up until it comes down.

Server:
-SQL Server 2000 SP4
-Windows Server 2003
-4 Intel Xeon Processors 5130 @ 2.00 GHz
-4 GB of RAM (SQL Configured Dynamically with min. of 0 and max. of 3072)
-Max Worker Threads – 255

Environment:
-100 users with about 65 on Thin Clients going through a Remote Desktop Server
-Front End CRM package is a program called Telescript
-I do not use replication or any triggers, mainly just scheduled DTS packages
-Largest and most heavily used Database is 13Gbs with using a fill factor of 80 on my indexes

Recent Changes – The most notable thing that I changed in the last couple of weeks as this problem arose was the SQL Mail function. I started using that and created some DTS packages that sent out emails. Our user base has been steadily growing, but nothing drastic.

So Far – The buffer cache hit ratio is good and I have not seen any problems with memory so that is ruled out. The processor time never maxes out, but it does appear to double when the Avg. Disk Queue Length spikes. I re-indexed my active tables and performed shrinks over the weekend, but the problem occurred yesterday again. Sometimes it will last under a minute, but the problem is really when it lasts for several minutes. I used SQL Profiler to try and identify what the query was causing the problem, and while I see some large audit times, I cannot tell what the problem is. I had a hard time reading through that with all of the Stored Procedures that were invoked (ie. cursor fetches). The server itself is very new and has only been in use for about 2 months, so I couldn’t imagine it would be hardware fragmentation.

QUESTION: What else should I be looking at or could I use to figure out where this problem is stemming from? I am in a corner and could use any suggestions as to diagnose this problem.

Thanks in advance,

Don
dkoehne@401kexchange.com

View Replies !

---

Should The Quorum Disk Be A Physical Disk Or Majority Node Set?
Hello,

   I am trying to setup a test cluster and am having an issue. When I try to create the resource of a physical disk it takes both the drive e: and drive q: and doesn't seperate them into two physical disks as resources. This means when I try to associate the quorum disk it links the to physcial disk resource of drive e and q. Then when I try to install SQL2k5 I get the warning about installing SQL on the quorum disk. Am I missing something? Is there a way to seperate e and q onto two physical disk resources so I can specifically associate the quorum to q and the sql to e or should I be setting the quorum disk to a majority node set? Thanks in advance.

John

 

View Replies !

---

Is It Possible To Move My Sql 2000 Database (in C Disk) To Another Disk (Disk) ?
hello,all
          I am new to Sql 2000,I installed sql 2000 database in C disk,but Now I found my C disk space is smaller than before,So I want to move my databse(include data and structure)   from C Disk to D Disk(its space is very large) .
         is it possible to do it ? 
         if its can be done ,do I need to change my asp.net program source code (exp: chaneg my crystal  report connectstring ) ?
        thanks in advanced!
 
 
 
      

View Replies !

---

Perfmon Disk Counter
May be I just lazy! (not refering to manual)
Does anyone know the "Disk second per transfer" in Perfmon include queuing time as well?

I have a measurement of 30ms per transfer. Is this figure include the queuing time in Windows or is it just the plain service time of the disks?

Thanks in advance.

View Replies !

---

SQL 6.5 And SQL 7 Instaled On The Same Physical Disk
Hi!
I have SQL Server 6.5 and SQL Server 7.0 instaled on the same
physical disk. Now I want to get rid of SQL Server 6.5.
Did somebody have situation like mine and tried to uninstall SQL Server 6.5.
What kind of problems have you had? How can I avoid them?
What kind of impact can be on NT registry?
Please share your experience.
Thank you,
Anny

View Replies !

---

Physical Disk Partitions
I just inherited a dev box, and need to do some performance analyzing on a 40 gig db for a client. Time is of the essence!

My question is that this dev box only has one disk partition (c: drive). Is it a huge deal that I don't have the db system files on one drive, with the data files on another, and tempdb on another,etc.....

View Replies !

---

Trying To Recover Physical Disk Space.
My SQL Server databases grew large. I deleted un-needed data from somedatabases. I then ran a stored proc that re-indexed the entire db. Mydatabase was 1.1 gig no the properties says it's 292 mb after I ranshrink database. I have a few other dbs I reduced in size. My physicalhard drive is 57% fragmented as reported by Disk defragmentor utility onmy Win 2k Adv Serv SP 4 server. I ran the defragmentor several timesand I'm unable to make any improvement. I also ran degfrag afterstopping all my IIS, SQL Server, and NetMeeting services. I still hadsome other services running.I want to defrag my physical mirrored disk volume.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View Replies !

---

Moving A Database To Another Physical Disk
I want to move 2 databases to another physical disk. They are both single file databases. It looks like a fairly straigtforward attach and detach procedure, but I have a couple of questions:

The log files (.ldf) currently reside on a separate physical disk from the data files, if I attach and reattach the data files will the logs remain where they are by default or do I have to re specify there location?

Is there any advantage to running the update statistics portion of the sp_detach_db?

View Replies !

---

Weird Physical Disk Access
Hi,

I have an MS SQL 2000 server running on a Proliat with two CPUs and 2GB RAM (the process actually uses 1.6GB).

For some reason, the same queries (which return the same data) run sometimes very fast and sometimes very slow.

I used the performance counter to find out that when the queries run fast there is little disk i/o and when they run slowly there is a lot of i/o.

I thought it happens because the DB keeps swapping tables in and out of RAM. The problem is that these things happen in periods. I can have a few hours of slow access and then a few hours of fast access. This makes me believe that it doesn't actually put the table in the cache untill it is requested enough times. Very weird.

HELP?

Thanks.

View Replies !

---

Move Log File To Another Physical Disk
Hi everyone,

Due to running out of disk space and reducing I/O contention, I plan to seperate data files and log files to different disk arrays.

My plan is to
- detach all databases
- copy log files to another disk
- attach all databases

The total size of log files is about 60GB. It becomes a problem becasue it spend too much time passing files. To reduce down time, is there any way I can do?

Can I just create new log files and remove the current files by using sql management studio?

any other suggestions? Thanks in advance

View Replies !

---

SQL Performance - Disk Queue.
 

I am running SQL server 2000 SP4 on a server with 2 Dual core 4G processors with data attached via a SAN>
 
I have a 70G database with 10 users that is giving attrocious performance. I have just tried to run a count(*) accross a couple of tables and am still waiting for the results 15 mins later. When I look at the disk queue it is around 50/60. I thought the target for this was around 2. I am sure that the hardware that we have in place is capable of running this db. However I`m not sure how to fully analyse what is going wrong here.
 
Any tips would be greatfully received.
 
Si

View Replies !

---

Avg Disk Queue Values
Again one client with SAN EMC and again performace is several times worse then you can have with a cheap and primitive IDE drive... :(

Anyway, my question.
I am monitoring many parameters, including Avg Read Queue and Avg Write Queue.
So if I ReadQueue=3 and WriteQueue=7, what does it mean?

Scenario 1, there are 2 different Queues (R- read request, W - write request):
Windows --> Device
Read. Queue: R:R:R
Write Queue: W:W:W:W:W:W:W

Scenario 2:
Windows --> Device
Common Queue: W.R.W.W.R.W.W.R.W.W

In other words, if SQL server flushes writes (TRAN COMMIT or CHECKPOINT), generating hundreds or even thousands of write requests in few milliseconds, so Queue grows to 100-300 for a second or so, are read requests locked during that time?

View Replies !

---

File Fragmentation And Disk Read Queue
I have a poorly performing SQL box.

I have run perfmon and the avg read queue length is pretty much permanently maxed out at 100%.

I have run a database index defrag.

On further inspection the file system is highly fragmented. There is a file fragmentation of 98% with the mdf file fragmented in 25,000 pieces. Running a standard windows defrag does not resolve this.

Two questions?

1- Is heavy file fragmentation of the MDF file a likely cause of the read queue length bottlneck?

2 - Why is the MDF file not defragmenting? Does the SQL server have to be taken offline? Is it possible to defrag a MDF file?

View Replies !

---

Get Total Disk Size And Free Disk Space
-- Initialize Control Mechanism
DECLARE@Drive TINYINT,
@SQL VARCHAR(100)

SET@Drive = 97

-- Setup Staging Area
DECLARE@Drives TABLE
(
Drive CHAR(1),
Info VARCHAR(80)
)

WHILE @Drive <= 122
BEGIN
SET@SQL = 'EXEC XP_CMDSHELL ''fsutil volume diskfree ' + CHAR(@Drive) + ':'''

INSERT@Drives
(
Info
)
EXEC(@SQL)

UPDATE@Drives
SETDrive = CHAR(@Drive)
WHEREDrive IS NULL

SET@Drive = @Drive + 1
END

-- Show the expected output
SELECTDrive,
SUM(CASE WHEN Info LIKE 'Total # of bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS TotalBytes,
SUM(CASE WHEN Info LIKE 'Total # of free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS FreeBytes,
SUM(CASE WHEN Info LIKE 'Total # of avail free bytes : %' THEN CAST(REPLACE(SUBSTRING(Info, 32, 48), CHAR(13), '') AS BIGINT) ELSE CAST(0 AS BIGINT) END) AS AvailFreeBytes
FROM(
SELECTDrive,
Info
FROM@Drives
WHEREInfo LIKE 'Total # of %'
) AS d
GROUP BYDrive
ORDER BYDrive

E 12°55'05.25"
N 56°04'39.16"

View Replies !

---

Disk Crash Of Disk That Contains The Paging File.
Hello,

this is my configuration :

1) 3 disks in RAID5 that hold the SQL data
2) 1 disk in RAID0 that holds the only paging file.

What will happen to the SQL data (DB) when the disk that holds the paging file crashes?

Kindest regards,
Luc.

View Replies !

---

SQL Server, Disk Arrays And Disk IO
Hi all,

Ok here goes,

I have a three tier system using SQL server 2000, we are currently experiencing IO bottle necks on our SCSI Raid 10 array, which holds the Data and the logs in separate partitions.

So my options as I understand it are:

Get Enterprise edition

or

Get another physical raid 10 array and separate the logs and data i.e. data on one array and logs on the other array.


I would like to try the latter but I am totally unsure how much difference this will make or whether it will make any difference at all.

Does anyone know how much performance increase I will get from using two arrays as opposed to one?


Any other advice on this scenario would be greatly appreciated.


Thanks

View Replies !

---

Disk To Disk Backups
Does anybody know exactly what happens within the SQL Server engine when backups are done? Specifically is tempdb used as a 'staging post' to write data to before it is written out to the backup directory?
The reason I ask is that during weekend, full database backups one of the stripe sets in my RAID array (there are 8 in total) is being hit VERY hard. I am trying to identify what is happening, hence the question.

If anyone has any thoughts or suggestions they would be gratefully accepted.
Jonathan

View Replies !

---

I/O Queue Length
Running transactional replication, dedicated server for distributor. While performance in terms of latency is excellent (usually 1 sec, almost never higher than 4) the disk queue length on the distributor is extremely high (over 6 usually). Is this typical? On any other server I would be very concerned, but cpu and memory usage are excellent and as said, latency is good. what is recommended config for distributor? others see high queue length?

View Replies !

---

Network Output Queue Length
On my busy sql server my network output queue length is a very large number 4343559902. My research shows it should be a < 2, but have also seen some bugs related to this perfmon counter. Anyone dealt with this issue before?

View Replies !

---

Calculating Length Of Time A Ticket Was Suspended
I'm trying to find a solution to for a report i am building and was hoping that some of you will share your expertise with me. Basically, I need to work out how long an Incident Ticket was suspended (ie it's status is "on hold").

The data is stored something similar to the following...

Ticket  Date                          Status
------     ----                              ------
333   14/03/2005 10:24:19 "to on hold"
333   14/03/2005 15:23:01 "from on hold"
334   14/03/2005 11:14:11 "to on hold"
334   14/03/2005 16:26:15 "from on hold"
335   15/03/2005 10:10:15 "to on hold"
335   15/03/2005 11:15:35 "from on hold"
335   15/03/2005 13:26:10 "to on hold"
335   15/03/2005 14:30:59 "from on hold"
335   16/03/2005 14:00:05 "to on hold"
335   16/03/2005 16:45:15 "from on hold"
336   16/03/2005 10:10:15 "to on hold"
336   16/03/2005 12:45:12 "from on hold"

This is the result i'd like to see....

Ticket  Start Hold                    End Hold                      Time Suspended
------     ----------                         --------                            --------------
333     14/03/2005 10:24:19 14/03/2005 15:23:01  datediff(...
334     14/03/2005 11:14:11 14/03/2005 16:26:15  datediff(...
335     15/03/2005 10:10:15 15/03/2005 11:15:35  datediff(...
335     15/03/2005 13:26:10 15/03/2005 14:30:59  datediff(...
335     16/03/2005 14:00:05 16/03/2005 16:45:15  datediff(...
336     16/03/2005 10:10:15 16/03/2005 12:45:12  datediff(...

Has anybody done something along the same lines? If so, could you point me in the right direction?

Thanks in anticipation

Jon

View Replies !

---

Calculating Length Of Service Categories Based On Start Dates
Ok, so I've been struggling with the logic behind this one for a while, so I thought I'd ask you guys for some ideas :)

Basically, I have the following table structure
Employee(employee_number, continuous_start_date, ...)

The problem lies in working out a summary of service categories (0-6months, 7-12months, 13-24, 25+).
I can work out the length of service in months with the following code

SELECT DateDiff(mm, continuous_start_date, GetDate()) AS 'Service in months'
FROM employee

So the first stage is to summarise the length of service into groups as mentioned above.

Then the final stage is working out how many people are in each group!

Hope I have given enough information - and please do not post a full solution - just some hints on how to get the desired result ;)

Thanks later, and in advance :p
-GeorgeV

View Replies !

---

DIsk Quotas
Hello,I am investigating setting up a shared sql server. I wish to enforcedatabase size quotas, and hopefully still allow customers to managethe creation of their own databases.Any thoughts or suggestions would be appreciated.Kind RegardsSimon Hall

View Replies !

---

Low Disk Space On C:
I noticed something strange today. I was running a query using query analyzer on a large database (8.8 million records) and the disk space on the c: drive was dropping and eventually went to 0. Availalbe space on the c: drive is 10GB. The query did complete. SQL server and all the databases are on the d: drive. After closing the query results in query analyzer the disk space returned. Is this a concern and is there a way to change it to use the d: for whatever it is doing?

View Replies !

---

Disk Fragmentation
What's the best way to find out if disk fragmentation on Windows 2000 Server is affecting SQL Server performance?

If disk fragmentation is shown to be a cause of performance problems, what are the recommendations for a disk fragmentation strategy? eg. use the win 2000 built in disk defrag utility or buy a 3rd party product like DiskKeeper? How much of an overhead is a product like DiskKeeper that defrags in the background?

Clive

View Replies !

---

Disk Full.
Hi all,
I have a problem...
I use SQL server 2000,all the disk on computer is used to store data file and transaction log file, and now they are full so data can be insert or update because the data file and transaction log file can be add more or increase, please show me.
Best regard,

View Replies !

---

No Place On Disk
I have one big db and i heve no place on disk
the log file is big too. how can i delete the log

View Replies !

---

SQL 6.5 And Disk Cloning
We need a drive cloning app, like Ghost, that will allow us to transfer a production image off of a HDD to other PCs. The problem with this is that
our production needs SQL in order to run and transferring the initial image to uniquely named workstations causes DB registration problems. Is there
an app that will allow us to configure this transferred image so that SQL will refer to the "new" drive instead in of the "old"?

View Replies !

---

DB Disk Space
In a fast growing OLTP database, disk space is critical. What, if any is the connection between the unallocated and unused space fields in sp_spaceused proceedure? Can unused table space really be reclaimed by the general database?

View Replies !

---

Disk Keeper
Dear All,
How are you?
NT 4.0 with Service Pack 5, SQL 6.5 with service pack SP5A.

Should I run Disk Keeper after stopping the SQL services for Disk Defragmentation?
You know the data always is important. Please correct me if I am wrong:

"We can't even copy or compress the SQL DAT files while the SQL services are running."

Thanks in Advance!!!!!!!

Kind Regards
SaDaT

View Replies !

---

High Disk I/o
Hello,

We are experiencing high disk i/o on one of our RAID disk systems. Can someone tell me how I can identify the query or user or process which is causing this high disk i/o?

Thanks,
Brent.

View Replies !

---

Disk Space
Does anyone know how to get the free disk space for all drives in many different SQL servers.

I need to populate a report (right now output in Excel) with the free disk space of all drives on all of my SQL servers.

I found xp_fixeddrives but that is specific for the server where it is executed.

Any help or pointers to a script in the archives is much appreciated.

Thanks.

View Replies !

---

Disk Fragmentation && SQL
One of my production servers has been determined to be 92% fragmented.

What's the proper procedure for defraging a database server?

I couldn't find anything very helpful in BOL, nor Knowledge Base.

Sidney Ives
Database Administrator
Sentara Healthcare

View Replies !

---

Disk Space
Hello
I need to setup a compaq sever with 300 MB database, and will be adding around 600 records on a daily basis. Can someone help with how much disk space i should have on sqlserver, providing i have c: and d: setup.

Thank you in advance for all the help.
Paula

View Replies !

---

Disk Space
Hi All,

I have a server and it has C: D: F: I: Drives and all the system files are on C:Drive and and all the .MDF's and .LDF's(model,temp,master) are on the F: Drive and now I am running out of space on both(C: and F: Drives)

1. Can we add space to the C: and F: drives on the fly?.
2. Can I move the System databases ( MDF's and LDF's to some other drive)and if so, how do I do it?( Moving the databases ) and this is on the production database so when I have to do this.Will there be any impact.

Thanks in Advance,
Reddy

View Replies !

---

Move Log To Different Disk
We will move t-log from one disk to another one. I tried Alter Database and found it did not work for log.

Can somebody give me a method about moving log from different disks?

Thanks.

Jean

View Replies !

---

Quorum Disk Again.
Hi,

I'm trying to install a server cluster to implement an SQL Server 2005 cluster. No other services (I think this is important).

I've a dual SCSI channel Smart Array with 4 disks configured in a 400Gb RAID 5.

I do not need to move different resource groups from one node to the other, I need only one group with all the resources IP, Network name, MSDTC, and SQL Server..., when a node fails, all services should failover to the other node.

Is it possible to have only one physical disk (RAID 5) for Quorum disk and shared disk?

It would be the following configuration:

[Groups]
    Cluster Group
          IP Address
          Network Name
          Physical disk (used for quorum and shared storage)
          Distributed Transaction Coordinator
          SQL Server
          SQL Server Agent
          Generic Service (SQL Server Fulltext)

The other option would be having a 1 physical disk Raid 0 for Quorum (146Gb wasted) and another physical disk Raid 5 (3 disk) for Shared Storage, but this schema will have a a flaw point that if Quorum disk fails, the cluster fails....

Any help would be appreciate.

Best regards.

Ilde.

View Replies !

---

Normal Disk IO
I am wondering what normal disk I/O should be.
i know it verys depending on use but im looking for an average.

here is an idea of what we have

there is about 10 centers doing replication to our primary server.
we have about 80 users connecting directoy to our primary server using MS Dynamics through CITRIX.
we have a few other apps use the database as well however i am fairly certin its Dynamics generating our disk IO
Hardware wise we have a powerful blade connected to a raid 5 SAN with 15000 rpm disks.
normaly the disk IO stays fairly low but every so often it goes crazy and im thinking it shouldn't

Below is a sample of our disk IO from perfmon over 2 minutes or so. as you can see everything looks ok untill 04/15/2008 10:12:49.470 when the Disk I/O % goes above 100%

"04/15/2008 10:12:23.470","2.8300181121159178"
"04/15/2008 10:12:24.470","0"
"04/15/2008 10:12:25.470","3.950025280161793"
"04/15/2008 10:12:26.470","0"
"04/15/2008 10:12:27.470","0"
"04/15/2008 10:12:28.470","5.9800382722449426"
"04/15/2008 10:12:29.470","7.7400495363170325"
"04/15/2008 10:12:30.470","3.4500220801413128"
"04/15/2008 10:12:31.470","0"
"04/15/2008 10:12:32.470","4.180026752171214"
"04/15/2008 10:12:33.470","3.8600247041581071"
"04/15/2008 10:12:34.470","0"
"04/15/2008 10:12:35.470","142.71091334984544"
"04/15/2008 10:12:36.470","0"
"04/15/2008 10:12:37.470","1.1500073600471041"
"04/15/2008 10:12:38.470","0.81000518403317789"
"04/15/2008 10:12:39.470","0"
"04/15/2008 10:12:40.470","2.1400136960876548"
"04/15/2008 10:12:41.470","10.230065472419025"
"04/15/2008 10:12:42.470","4.5800293121875981"
"04/15/2008 10:12:43.470","0"
"04/15/2008 10:12:44.470","0"
"04/15/2008 10:12:45.470","14.500092800593926"
"04/15/2008 10:12:46.470","6.730043072275663"
"04/15/2008 10:12:47.470","1.6300104320667652"
"04/15/2008 10:12:48.470","7.3500470403010585"
"04/15/2008 10:12:49.470","264.66169383484055"
"04/15/2008 10:12:50.470","324.18207476527851"
"04/15/2008 10:12:51.470","536.17343150996169"
"04/15/2008 10:12:52.470","270.31172999507197"
"04/15/2008 10:12:53.470","331.97212462159757"
"04/15/2008 10:12:54.470","333.84213658967417"
"04/15/2008 10:12:55.470","435.57278766584108"
"04/15/2008 10:12:56.470","442.31283080211716"
"04/15/2008 10:12:57.470","685.92438991609549"
"04/15/2008 10:12:58.470","295.1618890360898"
"04/15/2008 10:12:59.470","61.470393410517829"
"04/15/2008 10:13:00.470","56.360360706308519"
"04/15/2008 10:13:01.470","45.260289665853861"
"04/15/2008 10:13:02.470","224.58143732119885"
"04/15/2008 10:13:03.470","1022.0365410338626"
"04/15/2008 10:13:04.470","1114.6271336136551"
"04/15/2008 10:13:05.470","241.52154573789269"
"04/15/2008 10:13:06.470","506.79324347675828"
"04/15/2008 10:13:07.470","374.88239924735518"
"04/15/2008 10:13:08.470","359.5723012627281"
"04/15/2008 10:13:09.485","427.62119831413077"
"04/15/2008 10:13:10.485","400.15256097639025"
"04/15/2008 10:13:11.485","1076.2868882360847"
"04/15/2008 10:13:12.485","325.94208602935055"
"04/15/2008 10:13:13.485","449.36287592240592"
"04/15/2008 10:13:14.485","344.28220340610181"
"04/15/2008 10:13:15.485","569.57364527132972"
"04/15/2008 10:13:16.485","775.02496015974498"
"04/15/2008 10:13:17.485","729.54466908588222"
"04/15/2008 10:13:18.485","778.70498371189581"
"04/15/2008 10:13:19.485","1080.1269128122422"
"04/15/2008 10:13:20.485","754.56482921490704"
"04/15/2008 10:13:21.485","999.11639434492372"
"04/15/2008 10:13:22.485","701.36448873272786"
"04/15/2008 10:13:23.485","276.26176807531567"
"04/15/2008 10:13:24.485","252.13161364232732"
"04/15/2008 10:13:25.485","533.27341294984296"
"04/15/2008 10:13:26.485","759.54486108711092"
"04/15/2008 10:13:27.485","817.11522953746908"
"04/15/2008 10:13:28.485","129.41082822930068"
"04/15/2008 10:13:29.485","158.94101722251023"
"04/15/2008 10:13:30.485","160.55102752657618"
"04/15/2008 10:13:31.485","655.87419759486454"
"04/15/2008 10:13:32.485","444.49284475420637"
"04/15/2008 10:13:33.485","272.47174381916045"
"04/15/2008 10:13:34.485","94.730606275880163"
"04/15/2008 10:13:35.485","355.28227380655238"
"04/15/2008 10:13:36.485","898.29574909279427"
"04/15/2008 10:13:37.485","1309.3783800216322"
"04/15/2008 10:13:38.485","88.200564483612695"
"04/15/2008 10:13:39.485","1.2300078720503811"
"04/15/2008 10:13:40.485","4.9400316162023437"
"04/15/2008 10:13:41.485","217.90139456892524"
"04/15/2008 10:13:42.485","373.26238887928884"
"04/15/2008 10:13:43.485","73.760472067021226"
"04/15/2008 10:13:44.485","1.4100090240577541"
"04/15/2008 10:13:45.485","34.960223745431975"
"04/15/2008 10:13:46.485","15.990102336654955"
"04/15/2008 10:13:47.485","63.580406914604247"
"04/15/2008 10:13:48.485","26.560169985087906"
"04/15/2008 10:13:49.485","11.150071360456707"
"04/15/2008 10:13:50.485","15.250097600624644"
"04/15/2008 10:13:51.485","17.010108864696736"
"04/15/2008 10:13:52.485","12.210078144500125"
"04/15/2008 10:13:53.485","95.650612163917842"
"04/15/2008 10:13:54.485","38.740247937586801"
"04/15/2008 10:13:55.485","5.6000358402293777"
"04/15/2008 10:13:56.485","1.6600106240679942"
"04/15/2008 10:13:57.485","19.590125376802412"
"04/15/2008 10:13:58.485","2.8100179841150981"
"04/15/2008 10:13:59.485","631.48404149786563"
"04/15/2008 10:14:00.485","579.14370651972172"
"04/15/2008 10:14:01.485","1.0600067840434177"
"04/15/2008 10:14:02.485","15.870101568650039"
"04/15/2008 10:14:03.485","112.28071859659903"
"04/15/2008 10:14:04.485","15.660100224641438"
"04/15/2008 10:14:05.485","4.9800318722039822"
"04/15/2008 10:14:06.485","25.44016281704203"
"04/15/2008 10:14:07.485","16.130103232660691"
"04/15/2008 10:14:08.485","5.9300379522428939"
"04/15/2008 10:14:09.485","4.8400309761982481"
"04/15/2008 10:14:10.485","2.6400168961081349"
"04/15/2008 10:14:11.485","19.430124352795858"
"04/15/2008 10:14:12.485","42.55027232174286"
"04/15/2008 10:14:13.485","37.550240321538055"
"04/15/2008 10:14:14.485","1.210007744049562"
"04/15/2008 10:14:15.485","15.930101952652498"
"04/15/2008 10:14:16.485","20.550131520841735"
"04/15/2008 10:14:17.485","4.0900261761675267"
"04/15/2008 10:14:18.485","8.0100512643280908"
"04/15/2008 10:14:19.485","1.6000102400655365"
"04/15/2008 10:14:20.485","2.3300149120954372"
"04/15/2008 10:14:21.485","1.6200103680663558"
"04/15/2008 10:14:22.485","10.730068672439504"
"04/15/2008 10:14:23.485","4.4600285441826832"
"04/15/2008 10:14:24.485","9.0300577923698704"
"04/15/2008 10:14:25.485","0"
"04/15/2008 10:14:26.485","15.550099520636932"
"04/15/2008 10:14:27.485","2.970019008121652"
"04/15/2008 10:14:28.485","64.580413314645213"
"04/15/2008 10:14:29.485","71.850459842942996"
"04/15/2008 10:14:30.485","53.220340610179903"
"04/15/2008 10:14:31.485","32.620208769336124"
"04/15/2008 10:14:32.485","1.0000064000409603"
"04/15/2008 10:14:33.485","4.8400309761982481"
"04/15/2008 10:14:34.485","8.2700529283387425"
"04/15/2008 10:14:35.485","11.160071424457115"

View Replies !

---

DTS Disk Space
This is my first attempt using SQL 2000 and DTS. I am importing an Access database using the DTS wizard. The process fails with a "Not enough space on temporary disk" error. There is definitely enough space on the physical disk. I don't have any limits on any folder sizes either. What "disk" is the error talking about, and how do I give it enough space. The database is relatively small, about 10MB. I believe the database was created using Access 97. Please help.

View Replies !

---

Disk Organization
I understand the log files (LDF ) and data files (mdf ) should be on a different drives . I believe it leads to greater availabilty and speed . Are there any other reasons for to keep this on a separate drive.

Also what considerations I should take care while creating a database of around 100 GB . (use of filegroups , growth % etc ). Is there any connection of number of users to number of disks SQL data file to be spread to . Also do I need to take care (through hardware / software for a Quad core CPU ) to take full advanage of Quad core CPU.

View Replies !

---