Forum Replies Created

Viewing 15 posts - 22,696 through 22,710 (of 49,552 total)

  • RE: Vendor suggesting their issue is a limitation of sql server

    GSquared (10/26/2011)

    Actually, it takes work to truncate a log file without running a backup on it, like setting the database to Simple Recovery, running DBCC ShrinkFile, and then setting it...

    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

    October 26, 2011 at 1:25 pm

    #1399886

  • RE: Partial Backups to save space in disk

    10GB is tiny, far below where one would normally start with partial backups and piecemeal restores.

    Yes, you can do what you say, however make very, very, very sure you understand...

    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

    October 26, 2011 at 1:08 pm

    #1399876

  • RE: DETA recommendations..whats my next step?

    Sapen (10/26/2011)

    Technically I dont see any stored procs under the programmability-->stored procedures folder of this database.

    Ok, which has what to do with DTA and your indexes?

    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

    October 26, 2011 at 1:00 pm

    #1399873

  • RE: Vendor suggesting their issue is a limitation of sql server

    jared-709193 (10/26/2011)

    george sibbald (10/26/2011)

    Gus, I don't see that, you want log truncation, otherwise the log will just continue to grow.

    I believe this is wrong. When a log backup is...

    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

    October 26, 2011 at 12:59 pm

    #1399872

  • RE: DBCC checkdb fials on several databases, but not all

    spidey73 (10/26/2011)

    I checked the permissions. All databases are owned by sa.

    The user that runs the maintenance job in which all the checkdb commands are executed had got all permissions...

    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

    October 26, 2011 at 12:58 pm

    #1399871

  • RE: DETA recommendations..whats my next step?

    Sapen (10/26/2011)

    I ran a server side trace this morning and used the same to see what the DETA recommends for improvement in performance. Interestingly it recommended to create the indexes...

    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

    October 26, 2011 at 12:48 pm

    #1399863

  • RE: Vendor suggesting their issue is a limitation of sql server

    kstjacques (10/26/2011)

    Right now I have log backups running every 15 minutes for many DBs in my environment. This means there is a good chance it will happen at the...

    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

    October 26, 2011 at 12:34 pm

    #1399855

  • RE: Rule of thumb for determining PLE

    Personally my take on PLE is if it drops below what's normal for your system (sustained drop, not a spike), then there's potentially a problem. Jonathan's figure is great for...

    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

    October 26, 2011 at 11:02 am

    #1399794

  • RE: NULL, not 'NULL'!!!

    Ninja's_RGR'us (10/26/2011)

    This should really be reported as a bug to the ms folks.

    It's not MS's fault that a vendor app looks into a database table for connection data and blindly...

    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

    October 26, 2011 at 10:32 am

    #1399772

  • RE: Ciclic Redundancy Check error when read xxxxxx_9.ndf file

    jorge_gomes98 (10/26/2011)

    I tried backing up the DB ... mistake!

    What do you mean 'mistake'?

    If there are no backups of the initial DB is not my fault! ...i just followed orders.

    Are the...

    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

    October 26, 2011 at 10:24 am

    #1399770

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (10/26/2011)

    GilaMonster (10/26/2011)

    That's what they told me anyway, I bought my copies in person, so worth checking with Manning first.

    So you co-write the book and you still have to pay...

    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

    October 26, 2011 at 9:33 am

    #1399720

  • RE: Are the posted questions getting worse?

    GSquared (10/26/2011)

    I'm finding eBooks in the Kindle app on my Android table (double-check to make sure I hit all the necessary buzzwords there) are very, very convenient.

    Kindle/iBooks/PerfectReader on iPad here....

    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

    October 26, 2011 at 9:30 am

    #1399717

  • RE: Are the posted questions getting worse?

    BrainDonor (10/26/2011)

    GilaMonster (10/26/2011)

    BrainDonor (10/26/2011)

    No no no no no - if it doesn't make the bookshelf bend then it isn't worth buying. I haven't yet moved to ebooks (unless it's a...

    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

    October 26, 2011 at 9:28 am

    #1399713

  • RE: Ciclic Redundancy Check error when read xxxxxx_9.ndf file

    jorge_gomes98 (10/26/2011)

    Q1:

    the file is in the same filegroup...."Primary"....grrrrrrrrrrrrrrrrrrrrp

    Then that file contains pieces of all tables in your database, including the system tables.

    Q2:

    logs....i have lots of messages in windows event 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

    October 26, 2011 at 9:25 am

    #1399711

  • RE: Massive IOs!

    Ninja's_RGR'us (10/26/2011)

    Worse comes to worst I can come in for a quick consult to try and figure it out for you.

    Or I can do a remote perf review, or TheSQLGuru...

    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

    October 26, 2011 at 8:51 am

    #1399667

Viewing 15 posts - 22,696 through 22,710 (of 49,552 total)