Reputation
1,861
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
11 26
Newest
 Yearling
Impact
~119k people reached

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
Jul
15
comment Change Tracking Retention from a backup?
Test results inconclusive... sorry. See my updated post below.
Jul
15
revised Change Tracking Retention from a backup?
deleted 695 characters in body
Jul
15
revised Change Tracking Retention from a backup?
deleted 695 characters in body
Jul
15
revised Change Tracking Retention from a backup?
added 418 characters in body
Jul
14
comment Retrieving row count without using Count function
@a_horse ... good catch - the query ran as was but you're right the column alias should have brackets as well.