Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 9,715 total)

  • RE: SQL Server 2012 - High Memory Usage

    SQLRNNR (5/21/2015)


    Grant Fritchey (5/21/2015)


    One of your top queries is from Activity Monitor. You should probably not have it open all the time. You're actually adding load to the server...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Splitting TempDB - What's your experience?

    TheSQLGuru (5/21/2015)


    Since it wasn't mentioned in the original post I had assumed that temp object allocation wasn't an issue.

    These are brand new (and very beefy) servers for upgrading SQL...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Splitting TempDB - What's your experience?

    Thank you for the clarification, Gail. That gives me something to take to my boss (and something to ask our vendor about).

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Sean Lange (5/21/2015)


    cunningham (5/21/2015)


    soooo this is where you lot go to blow off steam!

    Yes indeed!!! Welcome to the "water cooler" commonly referred to as "the thread". 😀

    Sean, shame on...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Splitting TempDB - What's your experience?

    GilaMonster (5/21/2015)


    My usual recommendation to clients is:

    Split TempDB into 4 files, make sure they're all the same size, all the same growth increment. If I'm seeing obvious allocation contention...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Splitting TempDB - What's your experience?

    Kevin,

    I knew there was something regarding spindles involved. Thank you for the refresher. We'll check and see what they gave us before we make this decision.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Script Out Database Mail Settings?

    Lowell (9/8/2010)


    As a solution to my own question, one of the real problems is that a CREDENTIAL is created to hold the password for the SMTP user; i do not...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    I have a question on tempdb over here if anyone would care to drop by and share their thoughts.

    I'm kinda wishy-washy on this one. So some perspective would be helpful.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (5/20/2015)


    Ed Wagner (5/20/2015)


    Eirikur Eiriksson (5/20/2015)


    Grant Fritchey (5/20/2015)


    Eirikur Eiriksson (5/20/2015)


    GilaMonster (5/20/2015)


    Eirikur Eiriksson (5/20/2015)


    Grant Fritchey (5/20/2015)


    AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!

    I could see this one coming miles away, surprised how long it took.

    😎

    If it's...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: SQL Server 2012 - High Memory Usage

    Jeff Moden (5/20/2015)


    audiocool (5/17/2015)


    Hi Shawn,

    - OS and SQL Server 2012 are 64 bits

    - The server equipped with SQL Server 2012 and McAfee Virus Scan Enterprise v8.8

    - I...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/20/2015)


    Jason A. Long (5/20/2015)


    Brandie Tarvin (5/20/2015)


    Grant Fritchey (5/20/2015)


    Again...

    AAARRARARRGGGGHHHH!!!

    Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/20/2015)


    Again...

    AAARRARARRGGGGHHHH!!!

    Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random query hint. Things are...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/20/2015)


    AAAAAARRRRRRGGGGGGGHGHGHGHGHGHGH!!!!

    Dare we ask?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Here are some SQL Server Interview Questions

    SQLRNNR (5/19/2015)


    Eric M Russell (5/19/2015)


    But honestly, I could coach an average 12 year old how to fake their way through a SQL Server interview, if all it involves is...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Here are some SQL Server Interview Questions

    David Webb-CDS (5/15/2015)


    Your customer comes to you and says the query he has run daily for the last two years is suddenly taking hours instead of seconds. You gather...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 2,626 through 2,640 (of 9,715 total)