Forum Replies Created

Viewing 15 posts - 421 through 435 (of 758 total)

  • RE: Plan Cache Performance

    Grant Fritchey (9/17/2012)

    SQLSACT (9/17/2012)

    Grant Fritchey (9/14/2012)

    Those are valid counters and will show how your system is behaving. They're the same counters you get from running Performance Monitor. You can also...

    September 17, 2012 at 5:55 am

    #1538536

  • RE: Plan Cache Performance

    pooyan_pdm (9/17/2012)

    You should use the actual counter values from the sys.dm_os_performance counters for the three mentioned counters and for checking wheather the cache is bloating or not you can...

    September 17, 2012 at 4:28 am

    #1538492

  • RE: Select 2 tables

    Thanks

    September 17, 2012 at 1:01 am

    #1538417

  • RE: Plan Cache Performance

    pooyan_pdm (9/14/2012)

    Initial Compilation='SQL Compilations/sec'-'SQL ReCompilations/sec'

    plan reuse= ( 'Batch Requests/sec' - 'Initial Compilation')/'Batch Requests/sec'

    this one is more accurate

    Thanks

    How do I incorporate this into the script?

    I keep getting this error

    Operand...

    September 17, 2012 at 12:07 am

    #1538404

  • RE: Plan Cache Performance

    Grant Fritchey (9/14/2012)

    Those are valid counters and will show how your system is behaving. They're the same counters you get from running Performance Monitor. You can also look at sys.dm_exec_query_stats...

    September 17, 2012 at 12:02 am

    #1538403

  • RE: SQL Query Confusion

    GilaMonster (9/13/2012)

    SQLSACT (9/13/2012)

    Once the desired pages are brought into memory, can't the results then be presented? Is there still work to be done?

    Do you want a query that's intended to...

    September 13, 2012 at 10:25 am

    #1537331

  • RE: SQL Query Confusion

    GilaMonster (9/13/2012)

    SQLSACT (9/13/2012)

    When the query is submitted for the second time, SQL uses whichever Indexes and operators are in the compiled plan and only then SQL makes then realization that...

    September 13, 2012 at 6:05 am

    #1537150

  • RE: SQL Query Confusion

    GilaMonster (9/13/2012)

    SQLSACT (9/13/2012)

    GilaMonster (9/13/2012)

    SQLSACT (9/13/2012)

    When SQL Server brings pages into Memory, the pages sit in memory in the same way as they were sitting on disk?

    Meaning?

    When the query is submitted...

    September 13, 2012 at 2:13 am

    #1537056

  • RE: SQL Query Confusion

    GilaMonster (9/13/2012)

    SQLSACT (9/13/2012)

    When SQL Server brings pages into Memory, the pages sit in memory in the same way as they were sitting on disk?

    Meaning?

    When the query is submitted for the...

    September 13, 2012 at 1:42 am

    #1537038

  • RE: SQL Query Confusion

    GilaMonster (9/13/2012)

    First time:

    Query is compiled

    Query is executed

    Query processor asks for rows one by one from the storage engine according to the query operators in the plan

    Storage engine returns the rows...

    September 13, 2012 at 1:26 am

    #1537036

  • RE: SQL Query Confusion

    GilaMonster (9/12/2012)

    SQLSACT (9/12/2012)

    So when the same query executes again, the results can be found in memory, right?

    Results, no. The data pages that the previous execution used, yes (providing they haven't...

    September 13, 2012 at 12:11 am

    #1537026

  • RE: MCM Info

    GilaMonster (9/12/2012)

    SQLSACT (9/12/2012)

    I knew the title would get your attention 😉

    It nearly got you the attention of Microsoft's exam fraud division, and may still do.

    Report the post and ask Steve...

    September 12, 2012 at 8:15 am

    #1536734

  • RE: MCM Info

    GilaMonster (9/12/2012)

    SQLSACT (9/11/2012)

    Hi All

    Does anyone know where I can find braindumps for the Microsoft Certified Master SQL 2008 Exams?

    Just Joking!!!! :w00t:

    I should bloody well hope so. Be grateful I didn't...

    September 12, 2012 at 7:59 am

    #1536726

  • RE: Investigating the Plan Cache

    opc.three (9/5/2012)

    Correct to what end? What are you trying to figure?

    Current expensive queries

    And

    2.The script returns an execution_count and a use_count, am I right in that the execution_count is the amount...

    September 6, 2012 at 12:07 am

    #1534230

  • RE: Cluster - Nodes

    Perry Whittle (8/31/2012)

    SQLSACT (8/31/2012)

    I am removing a node from the Cluster to have it replaced with another node.

    ok, so perform the remove node on each clustered instance and finally evict...

    August 31, 2012 at 5:50 am

    #1532324

Viewing 15 posts - 421 through 435 (of 758 total)