Forum Replies Created

Viewing 15 posts - 31 through 45 (of 560 total)

  • RE: Question about msdb.dbo.backupset table

    It looks like I may have to increase worker threads on MSSQL and/or add more vCPUs:

    How It Works: SQL Server – VDI (VSS) Backup Resources[/url]

    I currently have above 200 databases...

    May 23, 2016 at 1:38 pm

    #1880879

  • RE: Question about msdb.dbo.backupset table

    So I have a very interesting meeting with IT. It's not only my SQL backups the ones that are failing, the VSS backups are failing too. Basically, whoever "grabs the...

    May 23, 2016 at 12:41 pm

    #1880869

  • RE: Question about msdb.dbo.backupset table

    TheSQLGuru (5/20/2016)

    1) Spread out your schedule to minimize overlap. I can't tell you how many times I see umpteen jobs starting at 00:00 (or on the hour) at clients!!! NEXT-NEXT-NEXT...

    May 20, 2016 at 4:10 pm

    #1880615

  • RE: Question about msdb.dbo.backupset table

    sql-lover (5/20/2016)

    Michael L John (5/20/2016)

    You will see "strange" entries in the msdb tables that correspond to backups created by Nimble protection manager.

    While the Nimble may be showing once second,...

    May 20, 2016 at 1:17 pm

    #1880590

  • RE: Question about msdb.dbo.backupset table

    Michael L John (5/20/2016)

    You will see "strange" entries in the msdb tables that correspond to backups created by Nimble protection manager.

    While the Nimble may be showing once second, the...

    May 20, 2016 at 1:14 pm

    #1880588

  • RE: Question about msdb.dbo.backupset table

    Lynn Pettis (5/20/2016)

    sql-lover (5/20/2016)

    TheSQLGuru (5/20/2016)

    sql-lover (5/20/2016)

    TheSQLGuru (5/19/2016)

    I have no idea about your Nimble stuff, but the backup start and end times should be set by the actual backup process in...

    May 20, 2016 at 12:31 pm

    #1880572

  • RE: Question about msdb.dbo.backupset table

    TheSQLGuru (5/20/2016)

    sql-lover (5/20/2016)

    TheSQLGuru (5/19/2016)

    I have no idea about your Nimble stuff, but the backup start and end times should be set by the actual backup process in SQL Server.

    Thanks for...

    May 20, 2016 at 8:51 am

    #1880521

  • RE: Question about msdb.dbo.backupset table

    TheSQLGuru (5/19/2016)

    I have no idea about your Nimble stuff, but the backup start and end times should be set by the actual backup process in SQL Server.

    Thanks for reply

    I guess...

    May 20, 2016 at 8:04 am

    #1880496

  • RE: Recurring deadlocks

    ChrisM@Work (3/24/2016)

    sql-lover (3/24/2016)

    ChrisM@Work (3/24/2016)

    Can you post the actual (not estimated) execution plan as a .sqlplan attachment please? It will answer a lot of questions.

    Rule #1 when dealing with a deadlocking...

    March 24, 2016 at 8:53 am

    #1867467

  • RE: Recurring deadlocks

    ChrisM@Work (3/24/2016)

    Can you post the actual (not estimated) execution plan as a .sqlplan attachment please? It will answer a lot of questions.

    Rule #1 when dealing with a deadlocking query -...

    March 24, 2016 at 8:36 am

    #1867454

  • RE: Recurring deadlocks

    Sachin Nandanwar (3/23/2016)

    You can use a UpdLock lockhint on Table1.Updlock allows other reads to acquire Shared locks but will block other transactions from trying to get update or X lock...

    March 24, 2016 at 7:20 am

    #1867409

  • RE: How to allow non DBA user to run SQL backup

    Lowell (3/22/2016)

    yeah i think you need to use sp_executesql and pass the two out parameters to get the errors that Redgates SQL Backup will return;

    it will tell you the exact...

    March 23, 2016 at 8:02 am

    #1867087

  • RE: How to allow non DBA user to run SQL backup

    ZZartin (3/22/2016)

    What error message is that user getting if you run just the EXECUTE master..sqlbackup ...... without any of the dynamic SQL or cross server stuff?

    None!

    It just does not run...

    March 22, 2016 at 12:46 pm

    #1866908

  • RE: How to monitor SQL activity on specific table?

    johnwalker10 (3/10/2016)

    check out the following link maybe this will help you out: http://serverfault.com/questions/111510/how-to-monitor-activity-on-a-single-table-using-sql-server-profiler

    Thanks for reply.

    But agree with Grant. Extended Events is more lightweight and I am trying to force myself...

    March 11, 2016 at 7:57 am

    #1864583

  • RE: How to monitor SQL activity on specific table?

    Grant Fritchey (3/10/2016)

    sql-lover (3/10/2016)

    Grant,

    I just tried that Extended Event session on my Dev box and it's not capturing anything 🙁 I tried a simple store procedure reading from a...

    March 10, 2016 at 1:11 pm

    #1864387

Viewing 15 posts - 31 through 45 (of 560 total)