|
dolphin123
Starting Member
USA
44 Posts |
 Posted - 12/11/2012 : 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
Flowing Fount of Yak Knowledge
United Kingdom
1770 Posts |
Posted - 12/12/2012 : 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 channels
3) What maintenance are you applying?
4)Is SAN replication turned on?
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
 |
|
SQL performance issue
