Forum Replies Created

Viewing 15 posts - 5,821 through 5,835 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Jack Corbett (5/22/2015)

    Question, how many of you work in an open work space? If you do, what are your thoughts?

    Hate it with a passion. Noisy, crowded, anyone...

    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

    May 22, 2015 at 7:26 am

    #1799990

  • RE: Multiple Apps in one Database

    Brandie Tarvin (5/22/2015)

    That being said... Yes, you could do backups for individual subsets of tables, assuming you put each applications schema on a different file. But as has been mentioned,...

    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

    May 22, 2015 at 5:18 am

    #1799960

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (5/22/2015)

    GilaMonster (5/22/2015)

    Yes, excellent idea, just go and change max server memory from ~28 GB with SQL using all of it down to 4GB and back up because that...

    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

    May 22, 2015 at 2:59 am

    #1799933

  • RE: SQL Server 2012 - High Memory Usage

    audiocool (5/22/2015)

    is the following service require to turn on

    SQL Server Analysis Service ?

    Are you planning to use it's features? Are you planning to build cubes, do data mining and 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

    May 22, 2015 at 2:58 am

    #1799932

  • RE: The Ol' PLE

    Henrico Bekker (5/22/2015)

    Hi Gail, just by looking at the service in Task Manager it's obvious it is idle.

    Any ideas?

    Yeah, stop using a tool which mis-reports memory usage. 🙂

    Task manager...

    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

    May 22, 2015 at 2:51 am

    #1799930

  • RE: SQL Server 2012 - High Memory Usage

    Please ask him to make sure that configurations are per the Microsoft KB articles

    https://support.microsoft.com/en-us/kb/2033238 and https://support.microsoft.com/en-us/kb/309422

    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

    May 22, 2015 at 2:42 am

    #1799928

  • RE: SQL Server 2012 - High Memory Usage

    audiocool (5/22/2015)

    What is pending:

    1) McAfee (Can't make any changes as setting is been locked by corporate team. Local IT also can't do anything. Will proceed after received feedback)

    And the query...

    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

    May 22, 2015 at 2:22 am

    #1799922

  • RE: The Ol' PLE

    Henrico Bekker (5/22/2015)

    The instance is not maxing out the allowed max memory either, it idles round the 536MB region.

    How are you getting that figure?

    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

    May 22, 2015 at 2:20 am

    #1799921

  • RE: SQL Server 2012 - High Memory Usage

    audiocool (5/22/2015)

    What is the recommended size for upper and lower limit since we have 32GB of RAM and space available in Drive C is around 60GB.

    Tiny. SQL Server does not...

    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

    May 22, 2015 at 2:19 am

    #1799920

  • RE: Scale out SQL Server Databases

    Immensely, incredibly, horribly difficult. There's no easy way to scale SQL out, just lots and lots and lots of work.

    Consider, if you can split clients among different DBs, put groups...

    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

    May 22, 2015 at 1:07 am

    #1799902

  • RE: Are the posted questions getting worse?

    Yes, excellent idea, just go and change max server memory from ~28 GB with SQL using all of it down to 4GB and back up because that 95% figure in...

    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

    May 22, 2015 at 1:03 am

    #1799899

  • RE: Should we set maximum memory setting for each SQL server?

    Always set max server memory. Always. Unless you like SQL and the OS to be constantly fighting over memory, which is what they will do if you don't configure it.

    http://www.red-gate.com/community/books/accidental-dba...

    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

    May 22, 2015 at 1:00 am

    #1799897

  • RE: SQL Server 2012 - High Memory Usage

    audiocool (5/21/2015)

    1) Min and Max (Default)

    2) Min (0) and Max (28GB)

    3) Min (4096) and Max (24GB)

    4) Min (5120) and Max (20GB) => Latest

    I still have the performance issue until now.

    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

    May 22, 2015 at 12:57 am

    #1799895

  • RE: Are the posted questions getting worse?

    jasona.work (5/21/2015)

    I was going to post this as a reply to this item: Distributed Replay Client but figured why post nothing of value to the topic at hand?

    So instead, here's...

    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

    May 21, 2015 at 10:31 am

    #1799764

  • RE: Buffer pool memory is higher than max server memory

    https://support.microsoft.com/en-us/kb/907877

    VM Reserved: This value shows the overall amount of virtual address space (VAS) that SQL Server has reserved.

    VM Committed: This value shows the overall amount of VAS that SQL Server...

    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

    May 21, 2015 at 10:19 am

    #1799757

Viewing 15 posts - 5,821 through 5,835 (of 49,552 total)