Viewing 15 posts - 226 through 240 (of 758 total)
SQLSACT (4/16/2013)
Perry Whittle (4/16/2013)
SQLSACT (4/16/2013)
Because Node1 has SQL installed as nonclustered, is it safe to say that it's not absolutely necessay to share DTC across all 3 nodes.
yes you...
April 16, 2013 at 5:08 am
Perry Whittle (4/16/2013)
SQLSACT (4/16/2013)
Because Node1 has SQL installed as nonclustered, is it safe to say that it's not absolutely necessay to share DTC across all 3 nodes.
yes you could...
April 16, 2013 at 5:07 am
My current setup is just a test setup.
Basically, what I am trying to do is way up is weigh up the Pros and Cons of moving to SQL 2012 AG's....
April 16, 2013 at 4:30 am
Perry Whittle (4/16/2013)
SQLSACT (4/16/2013)
By this do you mean it's not part of the storage allocated to the clustered instance of SQL Server?
Yep, MSDTC has absolutely nothing to do with...
April 16, 2013 at 3:39 am
Perry Whittle (4/16/2013)
SQLSACT (4/16/2013)
Nope - All Servers are in the same DCDC?
Datacenter
SQLSACT (4/16/2013)
Doesn't this take away from the seperate storage selling point of AG's combined with FCI?
No, the storage for...
April 16, 2013 at 3:05 am
Thanks
Quorum: What is the recommended Quorum configuration for my setup, I'm assuming Node majority.
Correct, for a 3 node cluster node majority is recommended.
Do the servers span multiple sites at all?
Nope...
April 16, 2013 at 2:17 am
GilaMonster (4/9/2013)
SQLSACT (4/9/2013)
GilaMonster (4/9/2013)
Are you just querying large tables or modifying them? If just querying, then you won't see any lazy writer activity as it has nothing that needs writing.
I'm...
April 9, 2013 at 8:58 am
GilaMonster (4/9/2013)
Are you just querying large tables or modifying them? If just querying, then you won't see any lazy writer activity as it has nothing that needs writing.
I'm just querying,...
April 9, 2013 at 8:34 am
From this website, download a book called Troubleshooting SQL Server: A Guide for the Accidental DBA by Jonathan Kehayias and Ted Krueger
Chapter 1.
April 5, 2013 at 12:15 am
I could be wrong but I'm sure that between sys.dm_db_index_physical_stats,sys.dm_db_index_operational_stats and sys.dm_db_index_usage_stats - 2 out of the 3 are reset when the indexes are rebuilt. Not 100% sure though
April 4, 2013 at 7:42 am
Check wait stats while the operation is running
April 4, 2013 at 7:29 am
What grouping are you trying to accomplish (max,min,avg,sum etc) ?
You could look at using over (partition by)
April 4, 2013 at 6:05 am
ChrisM@Work (3/27/2013)
Hover over each of those clustered index seek operators and examine the columns output. What would you want a lookup for?
Thanks
So because I'm joining test1.col1 = test2.col1 and they...
March 27, 2013 at 5:58 am
Viewing 15 posts - 226 through 240 (of 758 total)