Viewing 15 posts - 2,161 through 2,175 (of 9,241 total)
N.D (4/22/2015)
The queries that are suffering from contention are selects. The db ID in sysprocesses definitely shows as the user database and we're now using...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2015 at 1:38 pm
arrjay (4/22/2015)
How do I perform this? Is it as simple as creating a named instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2015 at 1:35 pm
yb751 (4/16/2015)
I'd just change the Transaction Isolation Level.
Careful here, my stairway series article at this link[/url] details the following
Stairway to HA Level 6
When you enable a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2015 at 1:33 pm
krypto69 (4/16/2015)
I have a SQL2014 server using high availability. So there is a primary and a secondary.
There is a vendor process that pulls allot of the data from a large...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2015 at 1:18 pm
imsqldba007 (4/17/2015)
Could you please some one share Clustering,mirroring and logshipping real time interview questions
Are you wanting guidance to ask these questions to a potential candidate or brain dump them so...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2015 at 9:02 am
PJ_SQL (4/17/2015)
When you Failover Node manually to another node, do we login to the server with virtual nameor physical name or would it matter at all?
If you want to fail...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2015 at 1:42 pm
baabhu (4/16/2015)
Server has a memory of 384 GB ram and we configured 372 GB ram in the SQLserver maximum memory.
I'd be granting a lot more than 12GB to the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2015 at 1:37 pm
mxy (4/15/2015)
My...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2015 at 3:06 pm
Maxer (4/15/2015)
So the listener is "for the availability group" not the instance itself, which makes sense if I think about it that way.Is that correct?
correct
Maxer (4/15/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2015 at 2:35 pm
jay-h (4/15/2015)
I'm Administrator on this server and the SQL instance.
This does not guarantee access to the file(s)
right click each file and select the properties then switch to security tab,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2015 at 2:18 pm
Maxer (4/15/2015)
Say I have 2014 AlwaysOn setup and working:
SQLNode1 ->Instance01
SQLNode2 ->Instance02
When I setup my listener: ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2015 at 2:04 pm
mxy (4/15/2015)
I have logshipping configured b/w Primary and DR site, Tlogs interval is every 15 minutes.
This frequency will apply to any secondaries setup against this primary.
mxy (4/15/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2015 at 2:02 pm
lsalih (4/15/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2015 at 7:27 am
lsalih (4/14/2015)
I know this is an older post, but I want to ask about what if I setup a primary cluster, then add the two nodes to the cluster?...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2015 at 7:19 am
Keith Hays (4/15/2015)
but Alwayson comes into play if you have a limited budget for hardware (no san).
If you have a limited budget and cant afford SAN then you'll likely not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2015 at 7:14 am
Viewing 15 posts - 2,161 through 2,175 (of 9,241 total)