Viewing 15 posts - 16 through 30 (of 284 total)
>>Raising the max server memory on each instance would be a sensible option
Yes, I understand your line of thinking, however, the failures *abruptly* started around 02/25/2015. Prior to that date,...
March 21, 2015 at 6:29 pm
Yes. We are using:
(128 GB - 12 GB) / 9 instances = ~12 GB max memory for each instance
We took this route because we did not want to overcommit RAM...
March 20, 2015 at 5:10 pm
All three nodes are essentially identical blades with 128 GB of RAM. I don't have access to the servers from home, but, as I recall (per Microsoft recommendation), we have...
March 20, 2015 at 12:59 pm
TheSQLGuru (2/3/2015)
The AWESOME, free Qure tool from DBSophic.com provides some amazing aggregate analysis features. You can't touch that tools capabilities with XEs.
Is DBSophic Qure Profiler still free? I am...
February 5, 2015 at 3:59 pm
Grant Fritchey (2/4/2015)
My book has been updated very extensively for SQL Server 2014.
I ran across a copy of your "SQL Server 2012 Query Performance Tuning" book this morning. This looks...
February 4, 2015 at 8:17 am
TheSQLGuru (2/3/2015)
You can get Tim Ford/Louis Davidson's free performance tuning with DMVs book. Glenn Berry's SQL Server Diagnostics Scripts. sp_whoisactive.
I didn't know about the Ford/Davidson book http://www.red-gate.com/community/books/dynamic-management-views. I...
February 4, 2015 at 8:14 am
We use our own custom PowerShell script (scheduled via Task Scheduler, not SQL Server Agent) to backup our databases because we have 40+ instances spread across several clusters, and it...
January 13, 2015 at 3:21 am
I'd still like to hear from someone who has actually created a (physical or virtual) cluster using SMB shares.
September 12, 2014 at 5:54 am
I ran across this link, in case anyone is looking for the same kind of information.
“Yes, today you can create an entire cluster based on SMB File shares.”
http://www.pythian.com/blog/smb-file-share-and-sql-server-an-option-to-consider/
September 12, 2014 at 5:48 am
By the way, we have been using 2012 for over a year, and our software is patched regularly.
September 10, 2014 at 11:11 am
We (3 DBAs) have not had any issues with our install.
September 10, 2014 at 11:11 am
>>Are all the servers in the same location?
Yes.
>>Are you running each SQL node on separate VM hosts?
We would prefer to do so.
Actually, that link is why I posted...
September 8, 2014 at 8:30 am
We never go it to work. We opened a call with Microsoft, and, to my dismay, Microsoft told me that this is unsupported software. Way to listen to your customers,...
May 28, 2014 at 3:00 am
We migrated to fresh hardware and fresh Reporting Services databases for SQL Server 2012. When I copied the Reporting Services reports to the new SQL Server 2012 instance, I noticed...
May 17, 2014 at 9:42 am
I'm not sure if this helped or not (because I found some additional links posted below at about the same time), but the description matched my error and the syntax...
March 4, 2014 at 5:28 am
Viewing 15 posts - 16 through 30 (of 284 total)