Forum Replies Created

Viewing 15 posts - 1 through 15 (of 121 total)

  • RE: Backup setup for AG

    andreas.kreuzberg - Friday, October 26, 2018 6:26 AM

    Hi,
    you should take a look on the page from ola hallengren

    https://ola.hallengren.com/sql-server-backup.html

    I agree 100%, I...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: SQL 2016 alwayOn AG failover failure when primary site went down

    I would check your quorum setup, it sounds like there weren't enough voting members to adequately vote to make the second site the primary.  I typically recommend a file share...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: AG SQL 2016 - Large Redo Que

    One thing that happened to a client of mine is that their "Power Mode" in the host BIOS (was a Hyper-V VM) was set to balanced.  If the server has...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Maintenance plan for backup failed

    Looks like it is running as the built-in service account.  Did you give that account permissions in the instance to perform backups?  It would also need permissions to whatever file...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Listner

    ramyours2003 - Tuesday, October 23, 2018 11:09 AM

    Iam having 3 ag   groups .can I use same listner in this case

    No, the listener...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Monitoring slow running queries of different variety of SQL Server versions without any 3rd party tool.

    I also like to use the First Responder Kit from Brent Ozar.  It's light weight and offers a wealth of information.
    https://www.brentozar.com/first-aid/

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Listner

    The number of nodes doesn't matter for the listener, it sits on top of the Availability Group.

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Get Index Fragmentation Cheaply

    Jeff Moden - Thursday, June 7, 2018 6:22 PM

    I don't know if cutting down on the number of joined tables will help...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Get Index Fragmentation Cheaply

    Thanks Jeff, I’ll give it a shot

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Opening Default Solution

    By the way, for anyone looking to do this, you just need to add the path to the solution to your shortcut Target path on the icon.  Be sure to...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: 3 Problems with a 4 node Cluster

    Exactly right, I've run into this before when requesting a new server from the infrastructure group...they always forget to add .net 3.5 and I always forget to check in advance.

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Can I install a windows cluster on an existing SQL server and set up AlwaysOn?

    All good info. Definitely use a file share witness, make sure that you have an AD service account running the SQL services before you get started and that it has...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: SQL 2016 SSRS failover cluster install

    As Sue suggested I believe you would need to install the component on server B then configure a new role for the service. I believe you can then add it...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Monitoring Azure SQL DB

    Grant Fritchey - Thursday, July 6, 2017 7:35 AM

    Mostly, I stick to the metrics supplied by the portal along with monitoring wait...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • RE: Monitoring Azure SQL DB

    Thanks for responding.  Yeah, those are helpful to a point.  I did some searching and found a cloud product called CloudMonix in the Marketplace that integrates into your Azure Portal...

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

Viewing 15 posts - 1 through 15 (of 121 total)