Reputation
1,931
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 12 29
Impact
~138k people reached

Jan
25
asked Merge Replication Invalid Object ( on an object that no longer exists ) ComErrorException
Dec
24
comment SQL Server: index creation date
Wow, ... usually I'm not that lazy. No problem - answer has been updated.
Dec
24
revised SQL Server: index creation date
added 585 characters in body
Sep
8
answered Will transactional replication push a CREATE INDEX immediately? Or do I need a snapshot?
Sep
7
comment SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
Thanks again... having spent the day monitoring performance ... the thing really is humming along nice - especially over the last single volume for everything raid 5 install. Still I got a lot of good info and education. I appreciate the advice.
Sep
7
accepted SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
Sep
7
comment SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
The actual images are stored as tiff's on a separate server as files. No blob's on the server (as far as laserfiche is concerned). But yep, you nailed it... all kinds of writing going on.
Sep
7
comment SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
I've uploaded a table as html code that contains the query results. I wasn't sure of a better way to do it. The volumns marked as T are trans log, those marked as H are data.
Sep
7
revised SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
added 25925 characters in body
Sep
7
revised SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
added 25925 characters in body
Sep
7
revised SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
added 7 characters in body
Sep
7
comment SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
Good catch... I actually mis-spoke in my original post. The tempDB is on a raid 1 (mirror pair).
Sep
7
revised Resource Waits: Mathematical link between Wait Time and Average Waiter Count
added 180 characters in body
Sep
7
asked Resource Waits: Mathematical link between Wait Time and Average Waiter Count
Sep
7
comment SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
I've updated my original question with queue lengths for the data vs log volumes on the san. I'll also add that our tempDB disk actually is a raid 1 (mirror pair) for the pof reason you caught.
Sep
7
revised SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
added 212 characters in body
Sep
7
comment SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
+1 just for the query... I'm looking it over now, but appreciate the suggestion. One of these days I'm going to get approved for a full week of DMV training. And "wildly different profiles" is a very good way to put it.
Sep
7
comment SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
I see Ozar has an upcoming webinar on SANs for DBAs... sanbasics.eventbrite.com hmmm, good timing maybe. His presentations are usually pretty good.
Sep
7
revised SQL Disk Setup Advice - TempDB, Log DB, Data file placement question
added 7 characters in body
Sep
7
asked SQL Disk Setup Advice - TempDB, Log DB, Data file placement question