Viewing 15 posts - 2,656 through 2,670 (of 9,244 total)
Its not clear what you need, do you want detail of all filegroups or just the default filegroup.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 5, 2014 at 12:56 am
SQL-DBA-01 (12/4/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2014 at 5:08 am
you're attempting to set the sql data directory to a non clustered drive by the look of it, could you post a screen shot of this section of the installer
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2014 at 4:44 am
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
Viewing 15 posts - 2,656 through 2,670 (of 9,244 total)