Forum Replies Created

Viewing 15 posts - 16 through 30 (of 1,518 total)

  • RE: Question on installing new active node in an active-passive cluster configuration after current active node has failed

    Thank you!

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 27, 2014 at 9:10 am

    #1692748

  • RE: Question on installing new active node in an active-passive cluster configuration after current active node has failed

    muthyala_51 (2/27/2014)

    Marios Philippopoulos (2/27/2014)

    No, the server itself is unusable; something happened and we are no longer able to even remote-desktop to it.

    It needs to be rebuilt and the SQL re-installed....

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 27, 2014 at 8:14 am

    #1692707

  • RE: Question on installing new active node in an active-passive cluster configuration after current active node has failed

    Perry Whittle (2/27/2014)

    Marios Philippopoulos (2/26/2014)

    We have an active-passive cluster with 2 nodes, A and B, hosting a failover-cluster SQL instance (FCI).

    When first installing the FCI, we first installed it on...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 27, 2014 at 8:09 am

    #1692705

  • RE: Question on installing new active node in an active-passive cluster configuration after current active node has failed

    No, the server itself is unusable; something happened and we are no longer able to even remote-desktop to it.

    It needs to be rebuilt and the SQL re-installed. Problem is this...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 27, 2014 at 3:32 am

    #1692595

  • RE: "Remote Login Timeout" and "Remote Query Timeout" configuration options

    MyDoggieJessie (2/6/2014)

    Remote Login Timeout: the time it takes to authenticate on a linked server before timing out. For example, if you are trying to log in to a remote server...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    February 7, 2014 at 3:13 am

    #1686947

  • RE: Offloading backups to AlwaysOn secondary replicas - any issues with copy-only full backups?

    Thank you all for your input.

    In our environment we are using AlwaysOn AGs with the async option, to prevent latencies on the secondary-replica side from affecting performance on the primary....

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 29, 2014 at 4:56 am

    #1684246

  • RE: Turbocharge Your Database Maintenance With Service Broker: Part 1

    srinath.m (11/12/2013)

    Good morning, Marios!! Here is the result of the query:

    ServiceQueueContract

    //UTILITY/UpdStats/InitiatorServiceUpdStats_InitiatorQueueNULL

    //UTILITY/UpdStats/TargetServiceUpdStats_TargetQueue//UTILITY/Contract

    http://schemas.microsoft.com/SQL/Notifications/EventNotificationServiceEventNotificationErrorsQueueNULL

    http://schemas.microsoft.com/SQL/Notifications/QueryNotificationServiceQueryNotificationErrorsQueueNULL

    http://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerServiceBrokerQueuehttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho

    http://schemas.microsoft.com/SQL/ServiceBroker/ServiceBrokerServiceBrokerQueuehttp://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic

    Any clue, where did I go wrong 🙂

    Hmm, that output is correct.

    Can you go through the tips I mention in...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    November 12, 2013 at 10:58 am

    #1665816

  • RE: Turbocharge Your Database Maintenance With Service Broker: Part 1

    Bhuvnesh (11/12/2013)

    Why the database needs to be set "trust worthy" in case of SB ?

    Good question, I don't have a good answer to it. :w00t:

    I mention this briefly in Part...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    November 12, 2013 at 4:35 am

    #1665696

  • RE: Turbocharge Your Database Maintenance With Service Broker: Part 1

    srinath.m (11/11/2013)

    Marios, I've setup the database and ran scripts in the order they appear in supplementary material, but receiving the following error when triggered the job "dba - updStats -...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    November 12, 2013 at 4:23 am

    #1665694

  • RE: Turbocharge Your Database Maintenance With Service Broker: Part 2

    Thank you for the link and for sharing your experience.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    November 11, 2013 at 10:54 am

    #1665539

  • RE: System-health extended-event session does not capture latest deadlocks

    There has already been a connect item on this - opened last year:

    https://connect.microsoft.com/SQLServer/feedback/details/754115/xevents-system-health-does-not-catch-all-deadlocks#tabs

    It was closed with no resolution though, as far as I can tell...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 16, 2013 at 3:00 am

    #1642030

  • RE: System-health extended-event session does not capture latest deadlocks

    mthumphrey (8/15/2013)

    It's almost like the system_health EE session has stopped collecting deadlock events on this particular server. The last one i have is 5 days ago. Meanwhile, with...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 15, 2013 at 8:49 am

    #1641832

  • RE: System-health extended-event session does not capture latest deadlocks

    mthumphrey (8/14/2013)

    I just figured out that I am having this same issue. the system_health EE session has fewer deadlock events that what is logged by trace flags 1204, 1222.

    Has...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    August 15, 2013 at 7:38 am

    #1641798

  • RE: The Intrusion of Life

    Just as with any relationship, the true colors of an employer will show in a crisis.

    It all comes down to how much an employer values someone as an employee and...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    July 21, 2013 at 5:18 am

    #1634305

  • RE: System-health extended-event session does not capture latest deadlocks

    SQLSalas (3/5/2013)

    I am seeing this same issue. I was trying to evaluate to make a switch from using Event Notification and going through Extended Events due to the "multiple-victim"...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    July 18, 2013 at 2:19 pm

    #1633793

Viewing 15 posts - 16 through 30 (of 1,518 total)