Forum Replies Created

Viewing 15 posts - 7,111 through 7,125 (of 49,552 total)

  • RE: DBCC CHECKDB keeps running every night

    tpsharp (12/2/2014)

    We are looking to move it to a hosted platform shortly which should resolve the issue, but this is a strange why this is running each day. This...

    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

    December 2, 2014 at 10:30 am

    #1762166

  • RE: Are the posted questions getting worse?

    Sean Lange (12/2/2014)

    This beauty was around 6,000 lines long. That was not a typo. It was a "single" query with something on the order of 200 instances of the word...

    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

    December 2, 2014 at 10:28 am

    #1762165

  • RE: Prevent a SELECT Query from returning results using LOCKS

    If you're trying to implement a checked in/checked out feature, please do some reading up first. It's one of those things that's easy to get wrong and very hard 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

    December 2, 2014 at 7:10 am

    #1762061

  • RE: Prevent a SELECT Query from returning results using LOCKS

    Because the one select took the lock, ran the select and automatically released the lock once it finished. The second would have waited for the first to finish (because 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

    December 2, 2014 at 6:57 am

    #1762055

  • RE: DBCC CHECKDB keeps running every night

    Grant Fritchey (12/2/2014)

    GilaMonster (12/2/2014)

    Grant Fritchey (12/2/2014)

    You may need to re-schedule them so they run less frequently, but you may just need to get more hardware.

    Or restore the backups to another...

    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

    December 2, 2014 at 6:55 am

    #1762054

  • RE: Are the posted questions getting worse?

    This is just a sheer lack of indexes (pk only on all tables), compounded with Entity Framework (so essentially SELECT * for all queries) and a lack of archiving.

    This...

    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

    December 2, 2014 at 6:52 am

    #1762051

  • RE: 42% of 100% taken in clustered index insert

    There will always be intent exclusive locks, that's a normal part of locking, nothing unusual 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

    December 2, 2014 at 6:47 am

    #1762045

  • RE: DBCC CHECKDB keeps running every night

    Grant Fritchey (12/2/2014)

    You may need to re-schedule them so they run less frequently, but you may just need to get more hardware.

    Or restore the backups to another server and CheckDB...

    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

    December 2, 2014 at 6:39 am

    #1762041

  • RE: Are the posted questions getting worse?

    For @#$^%&%$

    "The server's got 8 cores and 28GB of memory. It doesn't matter if it's scanning a 200 000 row table. It's not going to be a problem."

    From the CTO.

    Why...

    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

    December 2, 2014 at 6:33 am

    #1762038

  • RE: Prevent a SELECT Query from returning results using LOCKS

    XLOCK

    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

    December 2, 2014 at 6:29 am

    #1762036

  • RE: 42% of 100% taken in clustered index insert

    npranj (12/1/2014)

    Hence, my understanding that there must be page splits happening big time adding to this 42% cost

    The optimiser, which is what generates those estimated costs, does not have...

    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

    December 2, 2014 at 6:11 am

    #1762027

  • RE: DBCC CHECKDB keeps running every night

    Nothing will automatically cause SQL to run a CheckDB

    You probably have a job, or a job step in the backup job, which runs CheckDB on all databases.

    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

    December 2, 2014 at 6:04 am

    #1762020

  • RE: query is running fine few days before but now its taking more time in sql server

    Post the plans please, descriptions of them don't help.

    Plus table definitions, index definitions and the query itself.

    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

    December 2, 2014 at 5:41 am

    #1762012

  • RE: query is running fine few days before but now its taking more time in sql server

    What do you mean by 'recently'? More than a few days? From before the prod server started running slow?

    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

    December 2, 2014 at 4:57 am

    #1762000

  • RE: query is running fine few days before but now its taking more time in sql server

    And to check indexes on both and data volumes. If the data volumes are different between the servers, a different plan is expected.

    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

    December 2, 2014 at 4:50 am

    #1761997

Viewing 15 posts - 7,111 through 7,125 (of 49,552 total)