Forum Replies Created

Viewing 15 posts - 17,491 through 17,505 (of 49,552 total)

  • RE: Error 945: MSDB is not accessble

    Restore MSDB from backup.

    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

    July 21, 2012 at 4:41 am

    #1515836

  • RE: The transaction log for database is full

    SQL_Surfer (7/21/2012)

    reserved data index_size unused

    20416424 KB10244200 KB9928824...

    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

    July 21, 2012 at 4:32 am

    #1515835

  • RE: The transaction log for database is full

    SQL_Surfer (7/20/2012)

    Does OS server level configuration (for e.g Lock pages in memory or any other configuration settings on the sql server will have issue on the transaction log becoming...

    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

    July 21, 2012 at 4:28 am

    #1515834

  • RE: DBCC Hangs

    Ok, so more complex than tht

    Still, the easiest way to see when checkDB last ran cleanly is to look at the dbi_dbccLastKnownGood, which tells you exactly that, when checkDB last...

    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

    July 20, 2012 at 4:41 pm

    #1515802

  • RE: Perfomance Tuning

    There's one very fast way to resolve performance problems - hire a specialist to do it for 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

    July 20, 2012 at 4:34 pm

    #1515799

  • RE: Update Statement Crash gives additional errors than what's expected.

    Nested transactions are a lie. They don't really exist.

    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

    July 20, 2012 at 4:27 pm

    #1515795

  • RE: Perfomance Tuning

    devullapallymanidhar (7/20/2012)

    I just wanted to know like what all types of counters are to be checked during perfmon.

    (OR)

    and what values do we need to go though if we use DMV's...

    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

    July 20, 2012 at 4:22 pm

    #1515793

  • RE: The transaction log for database is full

    Check Books Online, it gives you the related DMVs and all details on what the column values show and mean.

    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

    July 20, 2012 at 4:20 pm

    #1515792

  • RE: DBCC Hangs

    opc.three (7/20/2012)

    If dbi_dbccFlags = 1 then it has never run clean.

    That just tells you whether data purity checks have ever been run and return clean, not if CheckDB has. If...

    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

    July 20, 2012 at 4:18 pm

    #1515791

  • RE: odd sproc behavior

    jerrycutshaw (7/20/2012)

    - Is it odd that of the 4 tables he is using dynamic SQL against it would report an insert error on the 3rd only?

    He's already got 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

    July 20, 2012 at 4:14 pm

    #1515788

  • RE: The transaction log for database is full

    That you do some investigation into whatever that was to find out why it is using a few GB of transaction log space.

    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

    July 20, 2012 at 1:55 pm

    #1515741

  • RE: The transaction log for database is full

    Sounds like the log's just not large enough for the activity on the DB. Do some monitoring, see how much log space the various transactions use

    sys.dm_tran_database_transactions

    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

    July 20, 2012 at 1:25 pm

    #1515720

  • RE: odd sproc behavior

    Dynamic SQL breaks the ownership chain. The user executing the proc requires permissions on the base tables as well.

    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

    July 20, 2012 at 11:50 am

    #1515682

  • RE: Dealing with a large tempdb log file

    Chrissy321 (7/20/2012)

    Am I correct in thinking that a restart will bring tempdb done to its initial configured size but that it is quite likely that whatever caused the log file...

    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

    July 20, 2012 at 10:58 am

    #1515659

  • RE: SP2 for SQL Server 2008R2

    You can, if you want the risk of running a pre-release (beta testing stage essentially) on your production server.

    Basically, if you want to do MS's testing on your production server,...

    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

    July 20, 2012 at 10:55 am

    #1515657

Viewing 15 posts - 17,491 through 17,505 (of 49,552 total)