Viewing 15 posts - 16 through 30 (of 286 total)
Wow! 2 GB for an RDP session? I didn't know that. Thanks, Eric.
December 8, 2016 at 1:31 pm
All your responses considered, I decided to act upon a variation offered by Jeff Moden.
In the SQL Server Properties GUI, Memory page, I set "Maximum server memory (in MB)" to...
December 8, 2016 at 1:30 pm
"Question, will you be running other services on the server, i.e. SSIS,SSRS,SSAS etc.?"
SSIS is running but rarely used.
December 8, 2016 at 12:40 pm
The server has 160 GB of physical RAM.
P.S. Thanks for the warning. Don't ask me why I appreciate your admonition so much.
December 7, 2016 at 5:03 pm
So, what is the appropriate setting in the Server Properties GUI, Memory page section, for the "Maximum server memory (in MB):" entry, to max the RAM allocation for the Standard...
December 7, 2016 at 4:45 pm
Thanks but it's not a math issue.
The issue is what does Microsoft mean in its licensing agreement when it states 128 GB?
December 7, 2016 at 3:43 pm
Actually, the I/O demands from the OLTP server are not extremely high. The CPU context switches metric is relatively low; there's not a lot of thread thrashing. The SQL Server...
December 2, 2016 at 5:47 pm
Michael, I responded to part of your suggestions in another post, want to complete it here.
The vendor won't tell us a lot about their hyper-convergence solution; it's patented, and I...
December 2, 2016 at 11:37 am
We don't know, Jeff. Right now, we're down to fault isolation strategies.
I intend to completely remove the TempDB database from the Simplivity disk system by placing it in RAM,...
December 2, 2016 at 11:22 am
Guru:
Yes. I suggested that exact solution (TempDB on SSDs) to the system manufacturer's reps. (That solution has produced outstanding results on other servers in previous jobs.)
The reps replied that...
December 2, 2016 at 11:09 am
Jeff Moden (12/1/2016)
Gail Wanabee (12/1/2016)
On a complete server reboot, can you recommend a way...
December 2, 2016 at 10:07 am
Jeff, I agree, I just didn't know you could do that. I'm not a Windows Server administrator.
On a complete server reboot, can you recommend a way to have a Powershell...
December 1, 2016 at 5:07 pm
Grant, this needs to implemented in a startup stored procedure in the master database, before SQL Server has actually started.
What I plan to do is to create a RAM...
December 1, 2016 at 2:39 pm
Jeff, we've looked as deeply as we can into what is a completely black box implementation and there's not much to see. The I/O delays on TempDB files are real...
December 1, 2016 at 10:13 am
Viewing 15 posts - 16 through 30 (of 286 total)