In followup to the SQL Server 2008 Best Practices Analyzer - keep an eye for the release post here, CSS SQL Server Engineers from PSSQL blog have announced .... SQL Server 2008 Best Practices Analyzer (BPA )
Server consolidation & virtualization is a hot topic and also it is one of the biggest concerns for many DBAs is scalability/performance when it comes to virtualization. At this point,performance for virtual machines can be close to, if not the same...
A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Read more from here.
You may be aware about SP_CYCLE_ERRORLOG from older SQL Server versions, this will only take care of SQL Server error log and not with SQLAgent error log. So the question is there any way out to recycle the SQLAgent log file too without restarting this...
