Viewing 15 posts - 421 through 435 (of 1,518 total)
Perry Whittle (10/6/2010)
Marios Philippopoulos (10/6/2010)
I just need a bit more ammunition to convince the SA team to make these changes.
Point them to the Microsoft KB and ask them to follow...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 6, 2010 at 11:00 am
I just stumbled on these links:
Windows Server 2008 Failover Clusters: Networking (Part 1)
Windows Server 2008 Failover Clusters: Networking (Part 2)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 6, 2010 at 10:33 am
Perry Whittle (10/6/2010)
Marios Philippopoulos (10/6/2010)
I just need a bit more ammunition to convince the SA team to make these changes.
Point them to the Microsoft KB and ask them to follow...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 6, 2010 at 10:24 am
Perry Whittle (10/6/2010)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 6, 2010 at 9:55 am
Perry Whittle (10/6/2010)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 6, 2010 at 8:49 am
Perry Whittle (10/6/2010)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 6, 2010 at 3:34 am
Perry Whittle (10/5/2010)
I'm assuming the network binding is the same on all nodes?Break the heartbeat team and use a single network connection only!
Thank you, but can you explain what this...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 5, 2010 at 7:40 pm
From Cluster Manager:
- Quorum Configuration: Node Majority
- Networks: Heartbeat Network, Prod Network
- Nodes: 3
I'm attaching screenshots you requested.
Thank you for the help!
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 5, 2010 at 3:19 pm
Perry Whittle (10/5/2010)
was it something I said :unsure:
Not at all! 😉
I've just been very busy, but let me get you some answers, back soon.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 5, 2010 at 2:49 pm
Perry Whittle (9/29/2010)
are you using a teamed connection for the heartbeat on your cluster nodes?
Also,
have you set your NIC settings and binding order correctly?
have you set the network types...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 30, 2010 at 9:13 am
Here is the cluster.log file, pls see attached; as a reminder, failover occurred on Sep 24th between 5 and 5:30 pm.
From what I could tell, there isn't much information on...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 28, 2010 at 9:34 am
MelS-512196 (9/28/2010)
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 28, 2010 at 8:20 am
Perry Whittle (9/28/2010)
ah yes 2008 is different, try exporting the log to a location you have permissions on
I'm connecting as the cluster admin, and I also tried exporting to D:\temp...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 28, 2010 at 7:48 am
Perry Whittle (9/27/2010)
Cluster.log should be in the following folder%systemroot%\cluster
Hmm, I'm on Windows Server 2008, cluster.log is no longer there. I'll use this link to get the log:
...
Getting access-is-denied errors when...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 28, 2010 at 4:00 am
george sibbald (9/26/2010)
the longest part of a cluster failover is usually recovering the database(s). Check the time of the first message in the errorlog...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 28, 2010 at 3:54 am
Viewing 15 posts - 421 through 435 (of 1,518 total)