SQL 2012 Best Practice Analyzer – An overview


Couple of days back Microsoft released BPA for SQL 2012.There are no major changes which I could catch within the tool and the whole install,scanning looked similar to the earlier version.SQL Server 2012 Best Practices Analyzer will offer scanning of both local computer and remote machines.

You would need Microsoft Baseline Config Analyzer 2.0 to use BPA,and we will scan the instance using Baseline config tool.

Both tools are available to download  -

BPA

Baseline Config Tool

We will get good amount of real valuable info using BPA and its pretty neat.

One of the interesting errors which I noted was related to Memory being paged out.I ran BPA on a virtual box with no instance level settings changed to simulate what best BPA is going to offer.

Category: Configuration

Source: localhost

Issue: The event log has messages that indicate that “Significant Portion of SQL Server Memory Has Been Paged Out”
EventId: 17890 Occurrence(s): 95 Last Occurred: 04/11/2012 11:05:31
WorkingSetOfSQLServerInstance – 110844
AvailablePhysicalMemory – 385012
TotalPhysicalMemory – 4193280
SystemMemoryState – Available physical memory is high

Impact: The performance and responsiveness of SQL Server services and associated applications may be affected when the processes are paged out

Conclusion

You have to use BPA in your environments and trust me,this will really help you to isolate issues well before  it becomes a problem.

 

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s