Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning All queries running slow after moving the db from staging server to production Server in SQL Server 2008 R2 RE: All queries running slow after moving the db from staging server to production Server in SQL Server 2008 R2

  • June 26, 2013 at 1:14 pm

    #1627697

    Kumar-386306 (6/15/2013)

    Exactly said. checking SAN is in progress now and expecting our Storage guys to see any abnormal settings done.

    BTW. Could you please let me know what SAN Setting was wrong on the machine which you faced issue? so that I could also look into it.

    For sure I know, I'm using Iscsi initiator to connect to the target, but I think the target LUN are created in 3rd party storage software where as the LUN are generated as .img files.

    I would like to know as well, please - we are going to move our DB to a server with SAN and local disk and I would also like to ask

    where would you suggest to keep data file and where - the log one (e.g. should we place data file on SAN and log file on a local disk?)

    Massive thanks in advance!