Alwayson availability groups failover monitoring - Part 1
There are a lot of ways to monitor AG, sql server errorlog, window event log, cluster log......, here I list...
2013-08-04
6,541 reads
There are a lot of ways to monitor AG, sql server errorlog, window event log, cluster log......, here I list...
2013-08-04
6,541 reads
Found a gap issue when using IDENTITY column in SQL Server 2012, every time I restarted sql server service, the current...
2013-07-23
3,746 reads
Sometimes you detach databases, or you delete a database which is in restoring status, the data and log file will...
2013-07-09
2,336 reads
1. 3004
show the internal backup/restore operation for every step.
ex.
dbcc traceon(3004,3605,-1)
GO
3605 means output the message to errorlog. you can use 3604...
2013-07-02
4,487 reads
4. Setup 2 nodes alwayson availability group
a) Enable alwayson on both 2 nodes
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-01\DEFAULT"
enable-sqlalwayson -Path "SQLSERVER:\SQL\SQL2012-02\DEFAULT"
b) Restore...
2013-06-25
2,241 reads
3. Install SQL Instance
a) Configure the firewall setting on both 2 nodes.
echo Default Instance
netsh advfirewall firewall add rule name="SQLServer"...
2013-06-25
2,098 reads
Here are some scripts which can be used for setting up 2 nodes AlwaysOn Availability Groups, you can make your own...
2013-06-25
2,523 reads
I must share it, there are many useful resource
http://blogs.msdn.com/b/mssmallbiz/archive/2013/06/18/huge-collection-of-free-microsoft-ebooks-for-you-including-office-office-365-sharepoint-sql-server-system-center-visual-studio-web-development-windows-windows-azure-and-windows-server.aspx?Redirected=true
http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more.aspx
http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/30/another-large-collection-of-free-microsoft-ebooks-and-resource-kits-for-you-including-sharepoint-2013-office-2013-office-365-duet-2-0-azure-cloud-windows-phone-lync-dynamics-crm-and-more.aspx
Thank you , Eric
2013-06-21
1,934 reads
when using table variable, please note table variable doesn't support transaction rollback. here is the words from BOL
Because table variables...
2013-06-20
2,728 reads
Say if you have a management server or a script repository server, sometimes users save/test/run their script from different path,...
2013-04-28
1,364 reads
By Brian Kelley
I may think I'm trying to reach the crowd, but I'm really trying to...
By Steve Jones
During a demo of Redgate Monitor Enterprise to a customer, they asked about how...
By Rohit Garg
What is Artificial Intelligence? Understanding Predictive vs. Generative AI Artificial Intelligence (AI) is transforming...
Hi, Is it possible to upgrade from sql server 2008 to sql server 2022,...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers