Forum Replies Created

Viewing 15 posts - 9,511 through 9,525 (of 49,552 total)

  • RE: performance tuning technical document template

    A what?

    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

    March 27, 2014 at 5:53 am

    #1700636

  • RE: Are the posted questions getting worse?

    That's a hell of a lot of sessions submitted...

    p.s. did you get the bribe I sent? :hehe:

    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

    March 27, 2014 at 5:43 am

    #1700633

  • RE: Sysdatabases Version NULL

    First things first. Stop using sysdatabases. It's deprecated, it's included only for backward compatibility with SQL 2000, it doesn't have columns for new features and it will be removed one...

    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

    March 27, 2014 at 4:49 am

    #1700621

  • RE: SQL INSERTS are significanlty slower on newer server

    What wait types are you seeing on your data modification queries?

    What do the disk latency counters look like (physical disk sec/read and physical disk sec/write)?

    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

    March 27, 2014 at 2:53 am

    #1700586

  • RE: Batch Request per sec

    Compare to previous baselines.

    Also, if the server isn't handling that number, you can't exactly go to the users and tell them to do less work. Rather you'd have to tune/upgrade...

    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

    March 27, 2014 at 2:26 am

    #1700578

  • RE: memory

    tony28 (3/27/2014)

    I was thinking about clean memory with statement such as if I will restart service or testing AlwaysOn function.

    What for? SQL is capable of managing its own...

    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

    March 27, 2014 at 2:24 am

    #1700575

  • RE: memory

    tony28 (3/26/2014)

    Guys, I understand that you dont understand why I want to do, but it looks that we have problem with disk subsystem.

    It is not possible to buy new...

    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

    March 27, 2014 at 12:55 am

    #1700561

  • RE: Batch Request per sec

    I've seen 10, I've seen 50000. You can't compare that number to someone else, it's about your specific workload.

    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

    March 27, 2014 at 12:51 am

    #1700560

  • RE: Page corrupted

    That is a corruption message (and would have been useful to post initially). If however you had something like an index rebuild run between the time you got the 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

    March 26, 2014 at 3:13 pm

    #1700479

  • RE: Page corrupted

    0 errors, so nothing's wrong.

    Message like what?

    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

    March 26, 2014 at 3:07 pm

    #1700476

  • RE: Page corrupted

    No idea, maybe if you post the actual message that you got from CheckDB

    That looks like a perfectly normal index page as dumped by DBCC Page.

    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

    March 26, 2014 at 2:32 pm

    #1700464

  • RE: Restore compressed backup creates 5x larger database

    Officially weird

    For completeness (and because I'm stuck for ideas), can you post the results of a RESTORE FILELISTONLY on both backups, as well as the output of a SELECT *...

    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

    March 26, 2014 at 11:59 am

    #1700427

  • RE: upgrade compatibility mode and rollback process

    Compatibility level you can change up and down as you like. It makes no changes to the database, it just affects how the parser and query processor treat some T-SQL...

    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

    March 26, 2014 at 9:35 am

    #1700367

  • RE: Partitioning table on a column that is not part of clustered index

    Please don't post multiple threads for the same question, it just wastes people's time as they have to reply in multiple places and makes things hard to follow.

    Please can we...

    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

    March 26, 2014 at 9:15 am

    #1700358

  • RE: Backup TAIL LOG when the DB is OFFLINE

    File extension can be .isanoddextension for all SQL cares. Extensions have no effect on behaviour

    Please note: 4 year old thread

    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

    March 26, 2014 at 9:14 am

    #1700356

Viewing 15 posts - 9,511 through 9,525 (of 49,552 total)