The SQL Server 2012 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature of SQL Server Management Studio. The reports allow a database administrator to quickly identify whether there is a current bottleneck on their system, and if a bottleneck is present, capture additional diagnostic data that may be necessary to resolve the problem.
Common performance problems that the dashboard reports may help to resolve include:
- CPU bottlenecks (and what queries are consuming the most CPU)
- IO bottlenecks (and what queries are performing the most IO)
- Index recommendations generated by the query optimizer (missing indexes)
- Latch contention
The information captured in the reports is retrieved from SQL Server’s dynamic management views. There is no additional tracing or data capture required, which means the information is always available and this is a very inexpensive means of monitoring your server.
Few report examples
The SQL Server 2012 Editions have been streamlined to better align with how customers are deploying applications and solutions. SQL Server 2012 will be released in 3 main editions*:
- Enterprise for mission critical applications and large scale data warehousing
- Business Intelligence, a new product edition, providing premium corporate and self-service BI
- Standard for basic database, reporting and analytics capabilities
Refer to Datasheet and FAQ for more details
- AlwaysOn Availability Groups
- Windows Server Core Support
- Columnstore Indexes
- BI Semantic Model
- User-Defined Server Roles
- Enhanced Auditing Features
- Sequence Objects
- Enhanced PowerShell Support
- Distributed Replay
- SQL Azure Enhancements
- Big Data Support
SQL Server Code Name Denali‖ is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and quickly build solutions to extend data across on-premises and public cloud backed by mission critical confidence.
Extend the reach of data virtually anywhere across server and/or cloud with expansive developer technologies, Enable new scenarios with SQL Azure DataSync, a cloud service that provides bi-directional data synchronization between databases across datacenter and cloud, Provide a consistent and open data-feed to power multiple user experiences across the web.
SQL Server code name “DENALI” CTP3 ..click here to download it
SQL Server code name “DENALI” Datasheet..download here from Microsoft
As a system integrator, My company, Elcome is well aware of the technologies available to make our clients lives easier…The deployment of Microsoft Dynamics has also had a major impact on the company’s ability to operate. “One big area that we’ve been able to focus on is reporting, in terms of KPIs and business intelligence. There have been a lot of advances in Dynamics and the supporting tools to make it easier to produce different types of reports, and the ability to allow end users to customise, specifically things like SQL reporting services that are part of SQL 2008. We were using an old version of Microsoft Dynamics GP. Two versions old in fact,” we realises. “When we upgraded to the latest version – and I think we were one of their first customers to go live with the latest version which is Microsoft Dynamics GP 2010 – we also moved to the latest versions of all the underlying technology. That includes the latest version of Microsoft SQL Server 2010. We’ve also moved from 32-bit to 64-bit servers. Everything is now running on 64bit hardware and software.” – explains executive director at Elcome International, Jimmy Grewal…more information read the following article published by ITP publishers on ACN Magazine By Ben Furfie Published May 10, 2011, May 2011 issue..click here to read more
The Microsoft® SQL Server® 2008 R2 SP1 Feature Pack CTP1 is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2. It includes the latest versions of:
- Redistributable components for Microsoft® SQL Server® 2008 R2 SP1 CTP
- Add-on providers for Microsoft® SQL Server® 2008 R2 SP1 CTP
Note: Some components in the Microsoft® SQL Server® 2008 R2 SP1 CTP Feature Pack of SQL Server® have certain Internet-enabled features, including the Customer Experience Improvement Program and Error and Usage Reporting component, enabled by default to help us identify and address issues that you may encounter while using SQL Server®. For more information and instructions on how to disable these features, see the SQL Server® Privacy Statement
Note:Some components in the Microsoft® SQL Server® 2008 R2 SP1 CTP Feature Pack of SQL Server® have two different methods to complete the installation process:
- Attended Installation – an interactive user interface will guide you through the set-up process and obtain all of the information and consent required to complete the installation. This includes the displaying, acknowledgement, and archiving of the applicable SQL Server license terms.
- Un-attend Installation – this is a DOS command Line set-up process that does not have an interactive user interface to guide you through the set-up process. In this case, you will be required to enter a parameter during installation that indicates your acceptance of the license terms.
More info click here
This conference, has been on March 1–3, 2011 at the Microsoft Fargo Campus, which provide insight, skills and knowledge that will help move the business forward..and its for Microsoft Partners only
- Interactive concurrent sessions – learn more about the solution from the Microsoft Dynamics GP team
- Roundtable discussions – visit with a small group on a variety of topics
- ISV Expo and reception – learn about the latest add-on solutions
Agenda as follows
The Road Map itself will give you how the GP future looks like…can’t wait to get hands on…
One of the good article about the The Evolution of the Microsoft Dynamics GP Roadmap from Mariano Gomez, Click here to read it
Again the coolest part is Microsoft Dynamics GP “12” will have a light deployment client as well as the current rich client, a web based client which will be capable of reproducing any Dexterity based window in an browser….cool naa..can’t wait to get hold of it..
I’m still wondering, when are they going to integrate the Active Directory integration of GP !!!
Here are some of the feature list of GP 2010 R2 highlighted in this conference
Waiting for the release!!!
A good blog from my colegue..I agree to that there should be customization quality, so that the upgrades/rollups are easy and the time comes after. Read more
Clicke here Vaidy Mohan’s Greatplains Blog
This year was a challenging year for us when it comes to ERP. Microsoft GP 8, we moved to GP10 and Microsoft released Great Plains 2010 and we decided to move to GP2010 because of the new features and collaborations. In 15 days we achieve this task by pulling the data from GP10 database, which is SQL2008 to GP2010 database. 15days with major customization on field service module, New codings on Analytical accounting and our in-house team is able to manage it well, within the time frame..and we are using all the below modules as well…
Now we are in Great Plains 2010…Congratulation to our team
GP2010 beautiful article…from David Musgrave…click here to read more
This message was quite annoying when my colleague created a Test Company in GP10 and restored a Production DB for R&D and Testing purpose. Analytical Accounting windows didn’t get opened and was throwing the following error message: There were several articles which cautioned / warned off from restoring only Company DB, which he is quite aware of. Because restoring another Company’s DB on to a Test Company will not have any issues unless it has got some products, like AA, depending heavily and real-time on DYNAMICS DB.
Read more..click Vaidy’s blog