Forum Replies Created

Viewing 15 posts - 796 through 810 (of 2,356 total)

February 1, 2021 at 11:28 am

#3839584

  • Reply To: Multi subnet failover cluster

    It sounds as if you would be better served by setting up an availability group and use Always On.

    https://www.sqlservercentral.com/stairways/stairway-to-alwayson

    January 26, 2021 at 2:52 pm

    #3837621

  • Reply To: Aliasing an instance name for remote connections

    On the client machines, make sure you have this in the registry:

    64 Bit alias

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo]

    "AliasName"="DBMSSOCN,Your FQDN of the Server,1433"

    32 bit alias

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\MSSQLServer\Client\ConnectTo]

    "AliasName"="DBMSSOCN,Your FQDN of...

    January 22, 2021 at 5:35 pm

    #3836379

  • Reply To: Alert Mechanism

    ramyours2003 wrote:

    I need to configure the below alerts manually for multiple servers

    Backup failure, disk space ,  long running queries, deadlock , memory utilisation >80,  primary datafile  growth etc,

    any scripts is...

    January 20, 2021 at 7:10 pm

    #3835621

  • Reply To: Interview question about CPU

    Lord Slaagh wrote:

    Thank you so much for your response. I worked with a DBA that said 99% CPU is ok because SQL Server hogs all the resources. That can't be right....

    January 18, 2021 at 3:47 pm

    #3834644

  • Reply To: exclude Always On Read-only databases

    This will filter for the local databases.

    SELECT * 
    FROM sys.databases 
    WHERE replica_id IS NULL

    January 12, 2021 at 2:08 pm

    #3831463

  • Reply To: exclude Always On Read-only databases

    Siten0308 wrote:

    Hello,

    I am writing a tsql statement but every time i run it, it comes up with error:

    The target database ('Database_Name') is in an availability group and is currently accessible...

    January 12, 2021 at 10:59 am

    #3831397

  • Reply To: Rebuilding and Reorganizing Indexes

    Jeffrey Williams wrote:

    At one time - there was a great push to use identity columns as the clustered index...because it would avoid fragmentation and you could just set it to 100%...

    January 9, 2021 at 11:27 am

    #3830342

  • Reply To: Are the posted questions getting worse?

    The baffling thing to me is why are these amazing conspiracy theories so believable, and spread so fast, when the simple answers are staring people in the face? Occam's Razor.

    Trump's...

    January 9, 2021 at 11:20 am

    #3830341

    • Viewing 15 posts - 796 through 810 (of 2,356 total)