also increase the journal size - chkdsk /L:65536 John MOSMWNMTK
Yes, as listed in the links in this thread. John MOSMWNMTK
chkdsk /L is non-destructive Disabling last access updates is non-destructive Changing the allocation unit size requires reformatting Disk...
"We seem to have a solution to this now, each of our Inserts was a new transaction requiring a buffer flush. Using Explicit Transactions seems to...
I think the question is: Where did all the IO go? I can think of a few things: 1. Track Alignment 2. Element Size/alignment 3. NTFS allocation...
Don't use the /3gb switch on 2000 standard, you'll be sorry. Likewise, don't use the /pae switch if you have 4GB of RAM. The /3gb switch, on 2000...
A couple counter you were missing: Disk Sec/write Disk sec/read There two counters are much more telling of an IO issue than queue length or %disk...
Topic 403 Gnotes doesn't play by the rules. They manipulate the registry directly instead of using the api, and they left a few things out. Great...
Think targeted resets. John Fullbright MOSMWNMTK
Multiple file groups can make sense for many reasons. One good reason is more threads processing IO. In a situation like SAP, where reads out...
Unless you're running SQL Server Enterprise on Windows 2000 Advanced Server, don't. 1. Windows 2000 Standard can't make use of either switch. 2....
If you use the /3gb or /PAE switch, you can rum low on page table entries. Using the the /3gb switch reduces the number available, while using /PAE...
I guess the place to start is the physical disk geometry. Most disks have 64 sectors per track. At 512 bytes per sector, that's 32K. When we...
The 64K allocation unit size for OLAP has it's merits. It can help mitigate the negative impact of prefetch in SQL 2000. When you read a large...
My focus has been storage on the Windows platform for some time now. I deal with all the storage platforms, but tend to have more experience with...
If you do that, you'll eventually have issues. There is no way to isolate the load on one logical from the load on another. heavy database read...
SQL can do ugly things to storage when it reads ahead 2000 pages. Be careful with that. You gave the server spec, but didn't talk about what type...
For the long winded explanation, see: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=382 The Clariion architecure has a few...
quote:Originally posted by Argyle Great post. A question about multipe logical drives on same physical disk. For example if you have 20 physical 9...
The problem isn#%92t confined to the HP EVA solution. It#%92s fairly common in SAN implementations.<br /><br />To better understand the problem, we...
Separate names with a comma.
