Forum Replies Created

Viewing 15 posts - 21,196 through 21,210 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    SQLRNNR (1/9/2012)

    That is a lot of books.

    That's my study, all those shelves (other than the one on the far left) is completely full with books piled on top of others...

    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

    January 9, 2012 at 12:05 pm

    #1430729

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/9/2012)

    jcrawf02 (1/9/2012)

    GilaMonster (1/9/2012)

    Ninja's_RGR'us (1/9/2012)

    There was a time I loved fiction, got any books to recommend?

    Yes

    http://sqlinthewild.co.za/index.php/2012/01/01/2011-book-review/

    http://sqlskills.com/BLOGS/PAUL/post/2011-the-year-in-books.aspx

    We both have 2010 posts as well if you feel like...

    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

    January 9, 2012 at 11:45 am

    #1430713

  • RE: Sysadmin fast , user logins slow

    SQLRNNR (1/9/2012)

    Continue to monitor CMEMTHREAD over time and watch how fast it grows.

    CMEMTHREAD is the name of the wait type, not the cache. The cache name is TokenAndPermUserStore.

    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

    January 9, 2012 at 10:29 am

    #1430667

  • RE: Sysadmin fast , user logins slow

    There's more options than that in the section in the book chapter, especially if you're on SQL 2008... Also, have you checked the cache size, confirmed the wait type, etc?

    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

    January 9, 2012 at 10:27 am

    #1430664

  • RE: Sysadmin fast , user logins slow

    Please check the links in the blog posts I mentioned, as well as chapter 3 in the book I recommended. I'm not saying this because I'm lazy, the symptoms and...

    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

    January 9, 2012 at 10:11 am

    #1430650

  • RE: Sysadmin fast , user logins slow

    Check and monitor to see if it is a token store problem first, if not, we can try and debug further.

    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

    January 9, 2012 at 10:03 am

    #1430640

  • RE: Sysadmin fast , user logins slow

    Nope, if it's token store it's not an execution plan-related problem. The queries will be exactly the same, will perform fast for sysadmin and slow for any other user showing...

    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

    January 9, 2012 at 9:50 am

    #1430624

  • RE: Sysadmin fast , user logins slow

    Yes, it's described in chapter 3 (the last 2 pages of it) of the book I listed, along with all the options (short term and long term) for fixing 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

    January 9, 2012 at 9:46 am

    #1430620

  • RE: Sysadmin fast , user logins slow

    First step, don't look at the cached plans (that won't give a difference between sysadmin and normal users unless there's something very strange been done), don't look at resource governor....

    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

    January 9, 2012 at 9:23 am

    #1430586

  • RE: Sysadmin fast , user logins slow

    This?

    http://sqlinthewild.co.za/index.php/2007/10/21/memory-and-sql-2005-sp2/

    http://sqlinthewild.co.za/index.php/2008/05/02/token-and-perm-user-store-growth/

    The blog posts are for SQL 2005, but the issue can come up on 2008 as well (just a lot less likely). See if you have the rest of 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

    January 9, 2012 at 9:09 am

    #1430570

  • RE: [Column] LIKE 'VALUE%' indexing?!

    SQL Kiwi (1/9/2012)

    SQL Server can quite happily seek on two LIKE predicates, whether they overlap or not.

    I know it can, but I've seen it do strange things with ORs before...

    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

    January 9, 2012 at 9:06 am

    #1430565

  • RE: Memory Allocation

    SQL doesn't segregate memory per database (except in terms of the data cache). You can check which DB uses up the majority of the data cache, you might be able...

    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

    January 9, 2012 at 9:05 am

    #1430564

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/9/2012)

    GilaMonster (1/9/2012)

    Roy Ernest (1/9/2012)

    I see lots of comments regarding post counts... Does everybody have a target?

    No, no targets here (though I'll take a screenshot of max_smallint when that happens)

    Would...

    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

    January 9, 2012 at 9:00 am

    #1430555

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/9/2012)

    There was a time I loved fiction, got any books to recommend?

    Yes

    http://sqlinthewild.co.za/index.php/2012/01/01/2011-book-review/

    http://sqlskills.com/BLOGS/PAUL/post/2011-the-year-in-books.aspx

    We both have 2010 posts as well if you feel like hunting

    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

    January 9, 2012 at 8:56 am

    #1430550

  • RE: Memory Allocation

    SQL will use as much memory as you allow it to use. If you feel that an instance is using too much, lower it's memory limit.

    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

    January 9, 2012 at 8:54 am

    #1430547

Viewing 15 posts - 21,196 through 21,210 (of 49,552 total)