Forum Replies Created

Viewing 15 posts - 24,496 through 24,510 (of 49,552 total)

  • RE: log file growing very large

    http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    August 3, 2011 at 10:19 am

    #1363207

  • RE: Database integrity maintenance job failing

    A severity of 10 is not an error. Doesn't matter what color it is, it's an informational message. What you're looking for in the trace is what that ALTER is...

    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

    August 3, 2011 at 10:15 am

    #1363202

  • RE: Database integrity maintenance job failing

    That's not an error. Sev 10 is an informational message.

    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

    August 3, 2011 at 9:21 am

    #1363150

  • RE: Database integrity maintenance job failing

    Ninja's_RGR'us (8/3/2011)

    Can you confirm that you are on SQL 7.0? (you posted on sql 2005).

    It's SQL 2005. The log he posted is clear about that.

    NEW COMPONENT OUTPUT

    Microsoft(R) Server Maintenance...

    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

    August 3, 2011 at 8:50 am

    #1363119

  • RE: Database integrity maintenance job failing

    jshurak (8/3/2011)

    Failed:(0) Alter failed for Server 'servername'.

    I think you want a trace to find out what's trying to alter what here...

    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

    August 3, 2011 at 8:35 am

    #1363103

  • RE: very slow query

    Ninja's_RGR'us (8/3/2011)

    Lucky9 (8/3/2011)

    I am very sorry for the late reply

    I have found the reason...

    Problem is with Index and I rebuild the index and it worked fine...

    I'd bet a lot 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

    August 3, 2011 at 8:34 am

    #1363098

  • RE: very slow query

    The other possibility that's just occurred to me is a large file copy. Those things tend to trash memory and disk IO. Can kill even the simplest query.

    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

    August 3, 2011 at 8:18 am

    #1363080

  • RE: SQL 2008R2 Express | SQL Agent help...Need to set up a backup scheduled task.

    Ninja's_RGR'us (8/3/2011)

    GilaMonster (8/3/2011)

    You don't need any software at all. Use the windows scheduler.

    Go sample backup code for that option? Never tried to make it work that way :ermm:.

    I don't,...

    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

    August 3, 2011 at 8:08 am

    #1363067

  • RE: SQL 2008R2 Express | SQL Agent help...Need to set up a backup scheduled task.

    AHWB (8/3/2011)

    so can anyone help with the syntax required as im not familiar with sqlcmd

    SQLCMD /? prints out the command-line options (like with most similar programs) or http://msdn.microsoft.com/en-us/library/ms162773.aspx

    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

    August 3, 2011 at 8:06 am

    #1363065

  • RE: SQL 2008R2 Express | SQL Agent help...Need to set up a backup scheduled task.

    You don't need any software at all. Use the windows scheduler.

    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

    August 3, 2011 at 7:27 am

    #1363030

  • RE: very slow query

    Ninja's_RGR'us (8/3/2011)

    My first impression was that the stats would containt info that each key would only have 1 value... hence still having really great estimates. But now that I...

    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

    August 3, 2011 at 7:25 am

    #1363028

  • RE: Shrink database while restoring

    chandan_jha18 (8/3/2011)

    But in case of log files, I have seen that if the log file is set to 5 GB as initial size and even if you back it 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

    August 3, 2011 at 7:05 am

    #1363008

  • RE: wait_type : CXPACKET - suspended

    One of those will have a wait_type other than CXPacket. What is that wait_type an what, if any, is the wait_resource?

    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

    August 3, 2011 at 2:06 am

    #1362854

  • RE: wait_type : CXPACKET - suspended

    ananda.murugesan (8/2/2011)

    Hi

    session_id : 53

    status : suspended

    blocking_session_id : 0

    wait_type...

    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

    August 3, 2011 at 1:38 am

    #1362849

  • RE: wait_type : CXPACKET - suspended

    sujitkmishra (8/2/2011)

    If still it's not killed then check the Unit Of Work (UOW) and kill all UOWs except all 0's.

    The Unit of work is purely for distributed queries running through...

    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

    August 3, 2011 at 1:32 am

    #1362847

Viewing 15 posts - 24,496 through 24,510 (of 49,552 total)