Forum Replies Created

Viewing 15 posts - 20,836 through 20,850 (of 49,552 total)

  • RE: TempDB Log Growth Help

    Is that what it is now, or what it was at the time the log was growing?

    If now, that's not going to tell you anything, you need to check...

    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

    January 22, 2012 at 12:51 pm

    #1436914

  • RE: Help with DBCC CHECKDB output

    Ah, well no page restores in simple recovery.

    So the table can be completely recreated from another source? If so, then just run checkDB with repair and then sync up 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

    January 22, 2012 at 12:49 pm

    #1436912

  • RE: TempDB Usage Query

    Kwisatz78 (1/22/2012)

    When I looked at the running code for this I could see code like the following being run:

    insert [dbo].[PURCHPARMLINE] select * from [dbo].[PURCHPARMLINE]

    Is this the DBCC code repopulating 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

    January 22, 2012 at 12:43 pm

    #1436907

  • RE: TempDB Log Growth Help

    What's the value of log_reuse_wait_desc for tempDB?

    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

    January 22, 2012 at 12:41 pm

    #1436906

  • RE: Help with DBCC CHECKDB output

    There are 3 pages damaged (27:59906941, 27:59906942, 27:59906943)

    Dropping the table should work as it will deallocate those pages. However if you have a clean backup and an unbroken chain of...

    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

    January 22, 2012 at 12:38 pm

    #1436905

  • RE: Help me: Many Tables to join.

    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    January 22, 2012 at 10:22 am

    #1436893

  • RE: Server for SQL Server 2008 R2

    And?

    There's info in chapter 1 on interpreting the perfmon and other stats and it points out that no single statistic alone is useful in diagnosis. Also, a single query of...

    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

    January 22, 2012 at 6:31 am

    #1436885

  • RE: Server for SQL Server 2008 R2

    Chapter 1 (and 2, 3 and 4) http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

    January 22, 2012 at 5:52 am

    #1436882

  • RE: Server for SQL Server 2008 R2

    meelan (1/21/2012)

    This comes with 8x600GB drives (more can be added) and my plan is to use RAID10. Since this server is for lot of transactions, I decided not to 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

    January 22, 2012 at 2:58 am

    #1436872

  • RE: Database Hung in Restoring State

    RESTORE DATABASE <db name> WITH RECOVERY

    If that doesn't work, the restore did not complete and you'll need to re-do it, either from scratch or WITH RESTART

    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

    January 22, 2012 at 2:43 am

    #1436870

  • RE: Backup does not complete SPID in Suspended State

    For SANs there will be vendor-specific tools (or there should be)

    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

    January 22, 2012 at 2:40 am

    #1436869

  • RE: Database Hung in Restoring State

    Messages in the error 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

    January 21, 2012 at 3:02 pm

    #1436836

  • RE: Help me: Many Tables to join.

    A scalar UDF accessing data in the select clause of a query, yeah it's almost certainly a problem, UDFs are (and they don't show up in execution plans or IO...

    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

    January 21, 2012 at 9:23 am

    #1436822

  • RE: SQL Server 2008 R2 SP1 64x cluster active/active

    Running facebook or something?

    Something at that scale is going to take some really good architectural design (not just database design) for not only the scalability but also maintenance, recoverability and...

    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

    January 21, 2012 at 9:21 am

    #1436821

  • RE: SQL Server 2008 R2 SP1 64x cluster active/active

    No, clustering for SQL is high availability only. What people mean when they say active-active is two different instances with two different sets of database one running on each cluster...

    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

    January 21, 2012 at 8:59 am

    #1436816

Viewing 15 posts - 20,836 through 20,850 (of 49,552 total)