Forum Replies Created

Viewing 15 posts - 391 through 405 (of 758 total)

  • RE: SQL Disk to Memory

    GilaMonster (9/26/2012)

    Maybe, but maybe not. Older pages may still get tossed out.

    Unless you have buffer pool > total size of all DBs in use, you can't assume that there will...

    September 26, 2012 at 5:20 am

    #1542318

  • RE: SQL Disk to Memory

    GilaMonster (9/26/2012)

    SQLSACT (9/25/2012)

    So if a query is submitted to SQL and the pages need to be brought into memory from disk and there is not enough memory to accomodate those...

    September 26, 2012 at 3:04 am

    #1542259

  • RE: SQL Disk to Memory

    Perry Whittle (9/25/2012)

    to TempDB

    Thanks

    So if a query is submitted to SQL and the pages need to be brought into memory from disk and there is not enough memory to accomodate...

    September 25, 2012 at 11:47 pm

    #1542210

  • RE: SQL Disk to Memory

    Perry Whittle (9/25/2012)

    laurie-789651 (9/25/2012)

    Perry Whittle (9/25/2012)

    SQLSACT (9/25/2012)

    Hi all

    I have a quick question regarding pages moving from disk into memory

    If I select * from a table, are all pages that make...

    September 25, 2012 at 10:21 am

    #1541975

  • RE: SQL Plan Cache - Database Autoclose option

    Grant Fritchey (9/25/2012)

    SQLSACT (9/25/2012)

    Grant Fritchey (9/25/2012)

    Yep. By design. Here's some description of it. Yet another reason to avoid auto_close.

    Ok, so I'm definately going to change the option to false.

    Question is,...

    September 25, 2012 at 6:47 am

    #1541830

  • RE: SQL Plan Cache - Database Autoclose option

    Grant Fritchey (9/25/2012)

    Yep. By design. Here's some description of it. Yet another reason to avoid auto_close.

    Ok, so I'm definately going to change the option to false.

    Question is, if I make...

    September 25, 2012 at 6:41 am

    #1541825

  • RE: Table/Index Storage

    Nils Gustav Stråbø (9/23/2012)

    The best way to find out how it calculates it is by starting a Profiler trace with a filter on your login.

    Will give it a shot

    Thanks

    September 23, 2012 at 2:38 pm

    #1541237

  • RE: Table/Index Storage

    Nils Gustav Stråbø (9/22/2012)

    Tom is correct, almost.

    All indexes will have a root page, but only if there are more than one data page. If there is only one data page,...

    September 22, 2012 at 4:02 pm

    #1541128

  • RE: Table/Index Storage

    L' Eomot Inversé (9/22/2012)

    No, they will be different.

    Your structure (with both the data and the index) is a tree of pages. The data pages are just the leaf pages...

    September 22, 2012 at 12:55 pm

    #1541111

  • RE: Understanding Page Splits

    GilaMonster (9/20/2012)

    Of course.

    Cool, thanks

    September 20, 2012 at 8:53 am

    #1540143

  • RE: SQL Performance Statistics

    Grant Fritchey (9/20/2012)

    SQLSACT (9/20/2012)

    Grant Fritchey (9/20/2012)

    SQLSACT (9/20/2012)

    Grant Fritchey (9/20/2012)

    SQLSACT (9/20/2012)

    Grant Fritchey (9/20/2012)

    19000 out of how many plans total? What kind of queries are being run against the system? I'm assuming...

    September 20, 2012 at 7:00 am

    #1540048

  • RE: SQL Performance Statistics

    Grant Fritchey (9/20/2012)

    SQLSACT (9/20/2012)

    Grant Fritchey (9/20/2012)

    SQLSACT (9/20/2012)

    Grant Fritchey (9/20/2012)

    19000 out of how many plans total? What kind of queries are being run against the system? I'm assuming these are not...

    September 20, 2012 at 6:49 am

    #1540044

  • RE: SQL Performance Statistics

    Grant Fritchey (9/20/2012)

    SQLSACT (9/20/2012)

    Grant Fritchey (9/20/2012)

    19000 out of how many plans total? What kind of queries are being run against the system? I'm assuming these are not parameterized queries or...

    September 20, 2012 at 6:42 am

    #1540038

  • RE: Understanding Page Splits

    GilaMonster (9/20/2012)

    Pretty much. The new page does not have to be page 11, can be any page anywhere in the filegroup.

    Am I right in that the non-leaf pages in the...

    September 20, 2012 at 6:40 am

    #1540036

  • RE: SQL Performance Statistics

    Grant Fritchey (9/20/2012)

    19000 out of how many plans total? What kind of queries are being run against the system? I'm assuming these are not parameterized queries or stored procedures? If...

    September 20, 2012 at 4:03 am

    #1539963

Viewing 15 posts - 391 through 405 (of 758 total)