Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dolphin123
Yak Posting Veteran
84 Posts |
 Posted - 2012-12-11 : 10:45:50
|
| Hi,We run the databases on new SAN environment.The database in question is used for data processing (ETL). It is taking abnormally long and I am trying to investigate. I see the following behavior:For this DB, the data and logs live on the same drive and when I check read/write, Data has 76 ms delay and log file has 3 ms delay.Looking the tempDB on the same server - I can see that the delay is more on Data then Logs file. Could this be that, the problem is with the application, not on the SAN or Disks.If I am going about this in the wrong directions, I would appreciate some pointers on where to look at.Regards,D |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-12-12 : 01:54:19
|
| 1) When it was running fast - was it on the same server \ doisk layout? In other words, has it suddenly gone slow?2) Without know the underlying details of your SAN configuration - is there any particular reason why data and log drives are on the same drive. ? Consider splitting onto separate drives - with separate IO channels3) What maintenance are you applying?4)Is SAN replication turned on?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
SQL performance issue