Post reply

SQL Server Clustering

  • October 13, 2004 at 9:15 am

    #86688

     I have recently set-up a two node active/passive SQL Server Cluster but have not completed one part of it and am looking for help.

    All the information I have read on clusters has told me to have 3 shared disks, one for the Quorum, one for the data files, and one for logs.

    The only thing I'm not sure about is the Logs. Is this for Transactions Logs or other types of logs.

    Any help would be much appreciated.

    Regards

    Pete Humble

  • October 13, 2004 at 10:52 am

    #526548

    http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp

  • October 14, 2004 at 4:29 am

    #526680

    If you're using the same shared storage unit, having a seperate partition for the TRANSACTION logs isn't going to make a massive difference performance wise because it's still using the same IO.

    However, saying that, it is probably still a reasonable plan to do this to :

    a) Keep things tidy

    b) Prevent Fragmentation (which WILL affect performance!)

    The latter can get to be significant if you have both the T-log and DB files on the same partition, especially  if you have AutoGrow on both the files and didn't deploy the initial database as an xGb file to start with. The 2 files start intermingling and the Defragmenting tool shows the drive to be the "Red Sea" !? If this does occur, you have the additional problem in that the defrag tool may not be able to rectify the problem because SQL Server has these files locked!

    Cheers

    Mark

  • October 14, 2004 at 1:03 pm

    #526826

    I have similar setup; one drive has data segments, another transaction log segments. The errorlogs I leave out on the "default" install directory.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply