How to use DTA (Database Tuning Advisor) with Plan Cache option?
SQL Server 2012 comes up with new workload option in DTA (Database Tuning Advisor). In addition, on existing options File or Table, Microsoft gives option to fetch workload from plan cache of SQL Server. In this case, the DTA will select the top 1,000 events from the plan cache based on total elapsed time of … Continue reading
SQL Server 20082008 R22012 || Remove Node from failover cluster
Steps to remove node from failover cluster for SQL Server 2008 onwards :- Note :- a) Same process will be used to remove node from failover cluster b) Same process will be used when you left with only one node, this will clear cluster group as well c) Old process of uninstallation from Add and … Continue reading
MSDB log file grown large – SLEEP_MSDBSTARTUP waittype
Issue: MSDB database log file is getting full very rapidly and became very huge. Currently, T-Log file is of 5GB whereas Data file is only 1GB for MSDB on server. Findings: We found system owned open transaction in MSDB which is causing issue. Transaction information for database ‘msdb’. Oldest active transaction: SPID (server process ID): … Continue reading
Cumulative Update – 8 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 8th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 8 contains all the hotfixes released since the initial release of SQL Server 2008 R2 SP2. Those who are facing severe issues with their environment, they can plan to test … Continue reading
We are Back Again..
After lots of crisis in last month, We are back again. Sorry for inconvenience caused ! Reference : Rohit Garg (http://mssqlfun.com/) You can find and follow MSSQLFUN :- http://www.facebook.com/mssqlfun http://mssqlfun.com/feed https://twitter.com/Rgarg86 Other Linked Profiles :- http://www.sqlservercentral.com/blogs/mssqlfun/ http://social.msdn.microsoft.com/Profile/rohitgarg http://www.toadworld.com/members/rohit-garg/blogs/default.aspx http://beyondrelational.com/members/RohitGarg/default.aspx
