Forum Replies Created

Viewing 15 posts - 7,456 through 7,470 (of 9,244 total)

  • RE: SQL2K8 Cluster Installation Error

    I have seen these issues before along with the SKU invalid error (appears when you try to add a node!).

    Slipstream the service pack during install to overcome these issues with...

    October 30, 2010 at 4:42 pm

    #1244577

  • RE: SQL Server Breaks down for every 10mins

    pinnamaneni.pavani

    could you provide info from the cluster.log

    October 30, 2010 at 4:09 pm

    #1244576

  • RE: SQL Server Breaks down for every 10mins

    Jeff

    There isn't really any hard fast link for a fix, it depends what the failure is. Each situation is taken on it's own merit.

    For instance something I have seen a...

    October 30, 2010 at 8:18 am

    #1244532

  • RE: Backup Strategy for System Databases?

    I always backup system databases once a day, for the size of them it's really no great shakes!

    October 30, 2010 at 3:02 am

    #1244505

  • RE: SQL Server Breaks down for every 10mins

    This is quite worrying too

    SQL Server error log

    2010-10-28 11:36:58.70 spid2s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration:...

    October 30, 2010 at 2:55 am

    #1244504

  • RE: AWE Memory

    nekonecny (10/28/2010)

    SQL server take more RAM, if SQL sever need it.

    [p]But You can set: [/p]

    [p]sp_configure 'max server memory (MB)',6144;[/p]

    [p]sp_configure 'min server memory (MB)',6144;[/p]

    [p]reconfigure with override[/p]

    Don't forget you will also need...

    October 30, 2010 at 2:48 am

    #1244503

  • RE: 24 x 7 x 365 HA environment

    Geoff A (10/29/2010)

    failover time with clustering = less than 1 minute more than 30 seconds.

    I have deployed previous clusters that can failover 2 instances of SQL server in around 15-20...

    October 30, 2010 at 2:39 am

    #1244501

  • RE: Update Statistics is Part of a Restore

    OK, now i know this is definitely related to your later question in this forum.

    Firstly please do not double post, it clogs the forum and can prevent your questions from...

    October 30, 2010 at 2:15 am

    #1244500

  • RE: Please HElp=Table access has become very slow after DB restore

    has the database been restored from a previous version of SQL Server.

    Try updating usages and rebuilding indexes would be my first port of call!

    October 30, 2010 at 2:08 am

    #1244498

  • RE: Issue with SQL Script.

    is this a graph produced in an SSRS report?

    October 30, 2010 at 2:06 am

    #1244497

  • RE: Moving clusters to new hardware - best plan?

    Mike Hinds (10/29/2010)

    a multinode cluster that consists of four active nodes, one primary passive node, and two alternate passive nodes."

    Yes, that is an Active\Passive cluster!

    October 29, 2010 at 7:32 am

    #1244172

  • RE: Why default instance is missing from node b

    This is already in discussion here too

    October 29, 2010 at 6:19 am

    #1244093

  • RE: Add a node to an existing cluster

    BigSam (10/28/2010)

    Thanks, I understand better now. Can you explain what happens in a 2-node cluster that is active/active? Does each instance 'mark' a database as active on that server &...

    October 28, 2010 at 3:05 pm

    #1243856

  • RE: Moving clusters to new hardware - best plan?

    Brian B. (10/26/2010)

    How is it a misconception? The target is a 3 node cluster - at any time two will be Active, and one will be Passive, thus Active/Active/Passive....

    October 28, 2010 at 10:43 am

    #1243705

  • RE: PAE Enabled without /PAE Switch ?

    homebrew01 (10/28/2010)

    My BOOT.INI is:

    [boot loader]

    timeout=30

    default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

    [operating systems]

    multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect

    We're running VMWare, if that makes a difference.

    I thought so, there you go!

    PAE is automatically enabled when DEP options are...

    October 28, 2010 at 10:24 am

    #1243692

Viewing 15 posts - 7,456 through 7,470 (of 9,244 total)