Forum Replies Created

Viewing 15 posts - 11,011 through 11,025 (of 49,552 total)

  • RE: T-SQL Performance tuning on Aggregates

    d_uvarajan (11/9/2013)

    Attached the execution plan. Please refer "Query 54" in the plan.

    Query 54 is 0% of the cost of the batch. Why do you think it's the problem?

    Can you go...

    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

    November 11, 2013 at 1:13 am

    #1665372

  • RE: Most frequent used stored procedures without access to system tables

    Jeff Moden (11/10/2013)

    The alternative is to get each stored proc to do it's own logging. With a little imagination and forethough, that's not as difficult to do as 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

    November 11, 2013 at 12:02 am

    #1665370

  • RE: Corrupt Backup File ?

    Jonathan's Troubleshooting book, memory chapter.

    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

    November 10, 2013 at 11:56 pm

    #1665369

  • RE: Craeting DR in sql 2012 standarad version for priamry server 2005 enterprise sp4

    Possible, yes, but a really bad idea. Failover would work, providing you have no Enterprise-only features but you wouldn't be able to fail back.

    DR should be the same version, edition,...

    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

    November 10, 2013 at 11:55 pm

    #1665368

  • RE: Corrupt Backup File ?

    3GB max to start with. Adjust as necessary.

    Still consider upgrading to 64-bit, if you've got a linked server driver causing MemToLeave problems, enabling AWE is not going to make 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

    November 10, 2013 at 10:12 pm

    #1665364

  • RE: Corrupt Backup File ?

    Yup, 32 bit. You don't have AWE enabled, so SQL can only use 1.7 GB of memory. You're probably running into fragmented virtual address space (or are out of virtual...

    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

    November 10, 2013 at 11:57 am

    #1665344

  • RE: Corrupt Backup File ?

    32-bit SQL installation?

    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

    November 10, 2013 at 10:11 am

    #1665342

  • RE: Corrupt Backup File ?

    homebrew01 (11/9/2013)

    Maybe the backups are getting corrupted somehow during ftp to the target servers.

    Wouldn't be the first time I've heard of that happening.

    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

    November 10, 2013 at 2:55 am

    #1665333

  • RE: Page Splits

    Should be in one of these:

    http://technet.microsoft.com/en-us/sqlserver/gg313760.aspx

    http://technet.microsoft.com/en-us/sqlserver/gg508878.aspx

    I don't offhand know of any articles specifically on page splits and I'm sure you can google as well as I can.

    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

    November 9, 2013 at 12:42 pm

    #1665311

  • RE: Page Splits

    That'll require half an article to explain from start to finish. Any specifics you want clearing up?

    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

    November 9, 2013 at 8:16 am

    #1665303

  • RE: restore db

    That the database is in a restoring state (it's in the middle of a restore) and hence SQL can't run recovery on it at this point in time.

    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

    November 9, 2013 at 2:03 am

    #1665288

  • RE: INDEXES

    Start with these:

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    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

    November 8, 2013 at 11:24 am

    #1665198

  • RE: Curiosity on performance increase

    This perhaps?

    http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/

    Or other parameter sniffing problem. Basically, SQL can sniff parameter values and use those to estimate row counts for query optimisation. It can't with variables. If it gets 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

    November 8, 2013 at 8:46 am

    #1665146

  • RE: SQL Installations - What role does the installation keys play

    The key is just what edition gets installed. With the possible exception of one of 2012's editions, the key in no way affects the cores you can use or 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

    November 8, 2013 at 2:04 am

    #1665021

  • RE: Extended Events->System_health->Watch Live Data Output - Security_error_ring_buffer_recorded Events Query

    What log messages specifically are you seeing?

    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

    November 7, 2013 at 11:50 pm

    #1664998

Viewing 15 posts - 11,011 through 11,025 (of 49,552 total)