Following are some real time SQL Server 2012 Performance Dashboards, taken from a real time SQL Server 2012 environment:
EXPENSIVE QUERIES – CPU
EXPENSIVE QUERIES – DURATION
and much more…
It’s a great set of reports for every SQL Server DBA to understand his/her SQL Server environment.
In March 2012 (precisely 6th March 2012), Microsoft made available SQL Server 2012 Performance Dashboard Reports which can be used to identify whether there is a current bottleneck on the system, and if so, capture additional diagnostic data that may be required to resolve it.
More information on this can be read from the download page: Microsoft SQL Server 2012 Performance Dashboard Reports.
One point worth to be highlighted is that this doesn’t require Reporting Services to be installed.
It’s a very crucial and important tool for any database administrator.
Have you ever opened a standard GP stored procedure?
I do it at least on a weekly basis and have always found it impossible to read as it is. So I end up aligning the procedure first and then read it to understand the logic.
Not anymore. David has shared information on some portals which does this in seconds and give us an aligned code.
Standing out from his list is Poor SQL, from what I learned from my usage.
And there is a plugin for SSMS which does this from within SSMS. This tool is called SSMS Tools Pack.
That’s a great news for those who would love to know more about Microsoft SQL Server 2012.
Microsoft Press has released a FREE EBOOK detailing SQL Server 2012. And it has got 288 pages full of information and it’s free and we have several options of the file type; EPUB, MOBI & PDF.
Get your copy now and know what it is in Microsoft SQL Server 2012.
Mariano, in his new post, confirms that Microsoft Dynamics GP 2010 is compatible with SQL Server 2012. The post also has got links to both CustomerSource and PartnerSource.
This is a good news, since SQL Server 2012 will precede Dynamics GP 2013, which means customers would be first upgrading their SQL Server first.
SQL Server 2012 has got tremendous amount of features that are going to be crucial in future.
So let’s gear up for some serious upgrades.