Viewing 15 posts - 1,306 through 1,320 (of 9,244 total)
ramyours2003 (4/6/2016)
I have 32 processors in my server , can we create more than 8 temp files , if yes how ?
monitor for allocation contention, if it's an...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2016 at 1:56 pm
lmacdonald (4/8/2016)
I am just seeking some advice on how people generally perform SP installations on production mirrored servers. We generally suspend the databases then upgrade the mirror first. ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2016 at 1:53 pm
Snargables (4/6/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2016 at 1:51 pm
Chitown (4/8/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2016 at 1:49 pm
chewychewy (3/29/2016)
DB Version: SQL SERVER 2012 ENTERPRISE
OS: WINDOWS 2012R2 STANDARD
I have 2 separate domains which I don't have the option of setting up a trust. One is a production environment,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2016 at 12:23 pm
APA0876 (3/29/2016)
This is my current scenario:
SQL Server Failover Cluster (SQL Server 2014) , two nodes N1, N2, Active /Passive
SAN Storage (Primary)
I will have :
(Secondary SAN Storage - Secondary...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2016 at 12:18 pm
szejiekoh (3/30/2016)
But as far as I know WSFC required a shared storage.
It's not the WSFC that requires the shared storage, it's the application you provision on top that requires it,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2016 at 12:13 pm
why not increase the physical memory instead or is this not possible
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2016 at 12:08 pm
ico-601891 (3/30/2016)
I have an environment with two physical node, server1 and server2. Both of them are part of the SQL Server Cluster installation whos name's is SQL1 (the sql server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2016 at 12:06 pm
kyyo757 (3/29/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2016 at 12:04 pm
I'd start with the web server(s). Is this a single server system or tiered application setup?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2016 at 11:56 am
Joaquin-435851 (3/25/2016)
What you can do is create a windows cluster with a file share quorum, and use HADR "Always On
If you design and deploy your WSFC appropriately you shouldn't need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 26, 2016 at 3:11 am
JarJar (3/16/2016)
perry- the 2TB database is split into 8...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2016 at 11:20 am
if all LUNs are from the same SAN storage pool they'll share the same cache too, with multiple LUNs and multiple I\O requests to the same storage pool you may...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2016 at 10:15 am
The script is calling xp_fixeddrives which does not support mounted volumes. The disk space can be easily retrieved by either a Powershell query or a WMI query instead of ole...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2016 at 1:58 am
Viewing 15 posts - 1,306 through 1,320 (of 9,244 total)