Forum Replies Created

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

  • RE: How to show the duration of SPs called from master SP

    Silverfox (9/30/2009)

    I have heard that UDF's; while not technically stored procedures will get traced with the statement level events, such as SP:StmtStarting

    Yup, but so will every other statement in 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

    September 30, 2009 at 1:42 am

    #1059836

  • RE: Table design and structure. Help needed on applying correct indexes.

    Please post table definitions, index definitions and execution plan, as per 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

    September 30, 2009 at 1:11 am

    #1059824

  • RE: How to show the duration of SPs called from master SP

    For the stored procedures, the event SP:Completed. Not sure offhand about the functions.

    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

    September 30, 2009 at 1:10 am

    #1059823

  • RE: Enabling traceflag 1222

    Glen Moffitt-317424 (9/29/2009)

    Thanks for pointing out that distinction. For tracking/gathering blocking information what method would you suggest?

    Query sys.dm_exec_requests. That will show you which connections are blocked and which...

    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

    September 30, 2009 at 1:05 am

    #1059820

  • RE: Truncate log

    Lynn Pettis (9/29/2009)

    GilaMonster (9/29/2009)

    Please read through this - Managing Transaction Logs[/url]

    Add I must that article to the library in my sig block.

    Much more and your sig will be larger than...

    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

    September 29, 2009 at 11:52 am

    #1059645

  • RE: Truncate log

    Please read through this - Managing Transaction Logs[/url]

    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

    September 29, 2009 at 11:22 am

    #1059627

  • RE: Enabling traceflag 1222

    Glen Moffitt-317424 (9/29/2009)

    We've got a SQL 2005 database where we're experiencing some blocks once or twice a day. I've enabled the 1222 traceflag via DBCC TRACEON(1222,-1) using SQL 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

    September 29, 2009 at 11:20 am

    #1059626

  • RE: SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds...

    Abhijit More (9/29/2009)

    Gail,

    I read in one of the article we can turn off the message by running the traceoff flag 803

    That doesn't answer my question. Why do you want...

    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

    September 29, 2009 at 11:07 am

    #1059622

  • RE: SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds...

    It means your IO subsystem is not handling the load put on it.

    How to make it go away depends on how the system is set up currently. It may...

    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

    September 29, 2009 at 2:02 am

    #1059340

  • RE: History of the recovery models for a database

    It should be in the SQL error log. I know I've seen it there before.

    Date2009/09/28 11:29:55

    LogSQL Server (Current - 2009/09/28 11:29:00)

    Sourcespid52

    Message

    Setting database option RECOVERY to SIMPLE for database Testing.

    Otherwise 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

    September 28, 2009 at 3:17 am

    #1058930

  • RE: Using readpadd hint

    From Books Online:

    READPAST

    Specifies that the Database Engine not read rows that are locked by other transactions. Under most circumstances, the same is true for pages.

    If you're happy 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

    September 28, 2009 at 3:13 am

    #1058929

  • RE: Shrinking Database

    Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.

    Shrinking causes massive fragmentation and will just result in 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

    September 26, 2009 at 12:26 pm

    #1058756

  • RE: Help, my database is corrupt. Now what?

    glen.wilkinson 26480 (9/18/2009)

    Hi Gail,

    apologies if this is the wrong place to ask, but here goes.

    Definitely the wrong place. Please create a new thread in the Data Corruption forum with a...

    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

    September 21, 2009 at 2:38 am

    #1056122

  • RE: Are the posted questions getting worse?

    Grant Fritchey (9/9/2009)

    Oh, hey, Gail, I almost forgot. I remembere, barely, got to it during the Q&A, to put in a reference to the fiber optic laser beam assembler during...

    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

    September 9, 2009 at 1:31 pm

    #1051409

  • RE: Are the posted questions getting worse?

    Bob Hovious (9/9/2009)

    Durban? Hell, no. I'm in JHB.

    How close to District 9?

    No such place. It's based on the (in)famous District 6 in Cape Town.

    The movie was filmed in Soweto, which...

    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

    September 9, 2009 at 12:50 pm

    #1051358

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