Post reply

Profiler

  • June 14, 2011 at 8:52 pm

    #239251

    Comments posted to this topic are about the item Profiler

    Thanks

  • June 14, 2011 at 8:53 pm

    #1338741

    Nice question - straight forward, no tricks -- Thanks

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • June 15, 2011 at 12:13 am

    #1338773

    I guessed, and was correct, but the reference points to SQL 2000 BOL. I can't find this in current SQL 2008 BOL, but maybe I just haven't looked hard enough.

    Urbis, an urban transformation company

  • June 15, 2011 at 1:18 am

    #1338787

    Nice question thank you.

    Besides the explanation on the msdn link referring to SQL 2000: http://msdn.microsoft.com/en-us/library/aa173918%28v=sql.80%29.aspx

    there is also one msn article referring to SQL 2008 R2: http://msdn.microsoft.com/en-us/library/ms174203.aspx

    Regards,

    Iulian

  • June 15, 2011 at 2:43 am

    #1338812

    Thanks for the question, I wasn't aware about this requirement.

    M&M

  • June 15, 2011 at 4:41 am

    #1338863

    Nice interesting question. I got it wrong and learnt something new.

    The reference to an SQL 2000 BoL page is a bit odd though. SQL 2005, SQL 2008, and Denali are covered by this page (which has 3 versions chosen by the (v=SQL.<version>) part of the URL.

    Tom

  • June 15, 2011 at 6:34 am

    #1338922

    Tom.Thomson (6/15/2011)

    Nice interesting question. I got it wrong and learnt something new.

    The reference to an SQL 2000 BoL page is a bit odd though. SQL 2005, SQL 2008, and Denali are covered by this page (which has 3 versions chosen by the (v=SQL.<version>) part of the URL.

    Nice question! This reference is better than question reference.

  • June 15, 2011 at 8:11 am

    #1339003

    Iulian -207023 (6/15/2011)

    Nice question thank you.

    Besides the explanation on the msdn link referring to SQL 2000: http://msdn.microsoft.com/en-us/library/aa173918%28v=sql.80%29.aspx

    there is also one msn article referring to SQL 2008 R2: http://msdn.microsoft.com/en-us/library/ms174203.aspx

    Regards,

    Iulian

    Yes, thanks for the link.

  • June 15, 2011 at 8:52 am

    #1339037

    Tom.Thomson (6/15/2011)

    Nice interesting question. I got it wrong and learnt something new.

    The reference to an SQL 2000 BoL page is a bit odd though. SQL 2005, SQL 2008, and Denali are covered by this page (which has 3 versions chosen by the (v=SQL.<version>) part of the URL.

    Nice one Tom. I was wondering how you found this article. Three of us where I work have typed in the follwing string and it does not come up in the search results.

    SQL Server Profiler free disk space

    We removed the word disk and the 2005/2008 BOL article showed in the search result list.

  • June 15, 2011 at 9:09 am

    #1339061

    Nice question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • June 15, 2011 at 9:51 am

    #1339098

    Interesting question, if the disk dropped below any of the 1st 3 choices profiler would be my least concern.

    Got it right by a lucky guess.

    ---------------------------------------------------------------------
    Use Full Links:
    KB Article from Microsoft on how to ask a question on a Forum

  • June 15, 2011 at 10:04 am

    #1339107

    Trey Staker (6/15/2011)

    Interesting question, if the disk dropped below any of the 1st 3 choices profiler would be my least concern.

    Got it right by a lucky guess.

    This is 10 MB minimum of available free space in the users TEMP folder just to start the application.

    There are other articles on how to move the folder Profiler uses for TEMP storage to improve performance.

    The space used in the TEMP folder to gather trace information can become very very large so many users will move this off thier system drive if they have a choice.

  • June 16, 2011 at 6:05 am

    #1339606

    Always good to remember these things - but the Profiler would be the last thing on my mind if I only had 10MB space left on my disk 😉

  • June 20, 2011 at 7:39 am

    #1341194

    Nice question, thank.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 23, 2011 at 7:30 pm

    #1343450

    Good to know

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply