Viewing 15 posts - 5,821 through 5,835 (of 49,571 total)
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...
May 22, 2015 at 7:26 am
Brandie Tarvin (5/22/2015)
May 22, 2015 at 5:18 am
Eirikur Eiriksson (5/22/2015)
GilaMonster (5/22/2015)
May 22, 2015 at 2:59 am
audiocool (5/22/2015)
is the following service require to turn onSQL Server Analysis Service ?
Are you planning to use it's features? Are you planning to build cubes, do data mining and the...
May 22, 2015 at 2:58 am
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...
May 22, 2015 at 2:51 am
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
May 22, 2015 at 2:42 am
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...
May 22, 2015 at 2:22 am
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?
May 22, 2015 at 2:20 am
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...
May 22, 2015 at 2:19 am
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...
May 22, 2015 at 1:07 am
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...
May 22, 2015 at 1:03 am
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.
May 22, 2015 at 1:00 am
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...
May 22, 2015 at 12:57 am
jasona.work (5/21/2015)
So instead, here's...
May 21, 2015 at 10:31 am
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...
May 21, 2015 at 10:19 am
Viewing 15 posts - 5,821 through 5,835 (of 49,571 total)