Viewing 15 posts - 2,656 through 2,670 (of 9,241 total)
TJT (12/3/2014)
Would you recommend splitting TempDB into multiples files equal to the number of CPUs, for support of one major database?
Do you even have tempdb contention?
Rather than just blindly following...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2014 at 4:40 am
fileshare witnesses are mainly for geographically dispersed clusters, i find them flexible enough even for same site clusters. Of course where possible i want to use MNS only
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 8:56 am
don't bother with a disk witness and use a fileshare witness, this can be placed on a well connected peer server or even a domain controller.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 7:38 am
Welsh Corgi (12/2/2014)
Should I install SP4 of 2008 R2 before upgrading to 2012?What about 2005 SP4?
Thanks.
SP1 is the minimum req for 2008 R2, there is no SP4 that i can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 6:48 am
Perry Whittle (12/3/2014)
- How many nodes in the cluster?
- Are they all on same site?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 6:43 am
plamannkathy (12/2/2014)
I have just finished configuring my first test mirrored environment (High safety mode). I setup the database engine service accounts on each of the servers with domain\user.
I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 6:40 am
GBeezy (12/3/2014)
Does this type process work for the quorom?
No, see my post above for details of the quorum
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 6:38 am
sej2008 (12/2/2014)
I know Node and Disk Majority is recommended for Two Node windows clustering.
Instead of disk witness use a fileshare witness 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 6:37 am
GBeezy (12/3/2014)
All,I have a SQL Cluster that I manage, but did not build and was not with the company when it was built.
I feel your pain i've been there before....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 6:30 am
for sql server 2008, a principal mirror database can have only one partner.
You may have multiple principal databases on server A and have one mirrored to server B and another...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 6:13 am
JoshDBGuy (12/1/2014)
I have less than 4 cores so my current setting is 0. However, I see some recommendations to set it to "0 to N". Will this make any difference?
Check...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 6:11 am
TJT (12/1/2014)
How would you recommend partitioning the space (I am assuming you want 3 drives)?
You'll need as many drives as your design dictates, typically its BP to separate
OS =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 6:08 am
you need to supply a little more info on the intended setup. Will the VMs be using plain virtual HDDs on the ESX datastore or do you plan to attach...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 5:54 am
if the service is shutting down scripts will not be running.
What you could do is run a SP at each service start, or capture the service state from the Windows...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 5:51 am
ramana3327 (12/2/2014)
Currently we are using 3 production servers. In one production server we have one database has sensitive data.
Suppose we have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2014 at 5:48 am
Viewing 15 posts - 2,656 through 2,670 (of 9,241 total)