Forum Replies Created

Viewing 15 posts - 44,266 through 44,280 (of 49,552 total)

  • RE: Performance Implications of Database Snapshots

    Alberto De Rossi (9/23/2008)

    Nice article. Would you please briefly explain us how did you get the measures to do those graphics? Did you use profiler?

    I ran the queries with...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 8:45 am

    #875742

  • RE: Performance Implications of Database Snapshots

    Steve Jones - Editor (9/23/2008)

    IMHO, the biggest feature missing from SS2K5 in this area, is that we can't backup snapshots. Doesn't make sense to me. Let me stream out pages...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 8:43 am

    #875737

  • RE: Users: Are they active?

    fjmorales (9/23/2008)

    whow! Why its so dramatic the change?

    No idea. I didn't investigate it. We created out own custom trace based on the audit requirements we were under and implemented that.

    You...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 8:28 am

    #875702

  • RE: Transaction Log growing

    Since a differential is essentially a "snapshot" of the data at the time is it necessary to retain all of the previous differentials?

    It's not a snapshot of the data at...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 8:26 am

    #875700

  • RE: Unique NONCLUSTEREDCONSTRAINT

    465789psw (9/22/2008)

    just a heads up and my already know if you do not elect to add a UNIQUE NON CLUSTERED constraint

    SQL will elect to one on its own in...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 5:58 am

    #875576

  • RE: Performance Implications of Database Snapshots

    Andreas Berchtold (9/23/2008)

    We have a replication (many hundred of pocket pc's connected) and thus a snapshot.

    What I don't understand: Why more than 1 snapshot, isn't a snapshot "only" used to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 5:49 am

    #875571

  • RE: deleting the data

    bhuvnesh.dogra (9/23/2008)

    i know .....truncate cant be stopped by trigger 🙂 but

    can we think beyond the available features of sql 2005

    As a purely theoretical exercise?

    is there any sys ...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 5:46 am

    #875569

  • RE: I need your advice, please

    Also read through the articles section here. Here are lots of very good info there.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 5:38 am

    #875565

  • RE: A database backup scenario

    Ahmad Osama (9/23/2008)

    what if I dont have the tran log 1 backup

    You'll only be able to restore to Diff2. Trying to apply Tran log backup 2 will give an error...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 5:31 am

    #875560

  • RE: backups

    What is backup device 'dbpath'? Is there enough space on the disk?

    If you're running in full recovery, you must run log backups. If you don't the log file will grow....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 5:30 am

    #875558

  • RE: deleting the data

    bhuvnesh.dogra (9/23/2008)

    You can apply INSTEAD OF trigger FOR DELETE on that particular table

    Won't help against truncates. Truncate doesn't fire triggers.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 5:27 am

    #875556

  • RE: Performance Implications of Database Snapshots

    Matt Whitfield (9/23/2008)

    Chirag (9/23/2008)

    The pages from the source database get written to the snapshot's sparse file the first time the page gets modified in the source database. Is that right?

    If...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 2:49 am

    #875491

  • RE: Performance Implications of Database Snapshots

    Chirag (9/23/2008)

    Nice article Gail.

    The pages from the source database get written to the snapshot's sparse file the first time the page gets modified in the source database. Is that...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 2:47 am

    #875489

  • RE: Performance Implications of Database Snapshots

    Mike Metcalf (9/23/2008)

    We use Snapshots in our production system, what I am wondering is whether the snapshots for the tests were on the same disks as the main database file,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 2:45 am

    #875487

  • RE: A database backup scenario

    Given that, you would need to restore in the following order

    Full backup

    Diff 2

    Tran log 1

    Tran log 2

    The transaction logs form a chain and you need all of the tran log...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 23, 2008 at 2:34 am

    #875483

Viewing 15 posts - 44,266 through 44,280 (of 49,552 total)