Posted by dpless on March 22, 2012
By Joseph Pilov
SQL Server Performance Dashboard Reports for SQL Server 2012
You can download the reports here http://www.microsoft.com/download/en/details.aspx?id=29063
Description: 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
- 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.
Reporting Services is not required to be installed to use the Performance Dashboard Reports.
Posted by dpless on March 15, 2012
Tampa Bay SQL Server User’s Group meeting – March 20th @ 6:00pm (6:30pm official start)
Juvenile Welfare Board
14155 58th Street North
Clearwater, FL 33760
For more information on the Tampa Bay SQL Server User’s Group, contact: Pam Shaw email@example.com
David Pless will present SQL Server 2012: Implementing and Supporting AlwaysOn
SQL Server AlwaysOn is the new comprehensive high availability and disaster recovery solution in SQL Server 2012. Using AlwaysOn, you can increase application availability and get a better return on your hardware investments through a simplified high availability deployment and management experience.
We will talk about SQL Server 2012′s new feature SQL Server AlwaysOn and what it will mean for the DBA. We will cover how to set up AlwaysOn and the role of clustering in the new high availability / disaster recovery solution.
We will discuss Availability Groups, synchronization modes, the AlwaysOn dashboard, what to monitor with AlwaysOn, and other important support topics.
David Pless a Premier Field Engineer for Microsoft based out of Orlando, Florida will return to discuss some new availability features in SQL Server
Posted by dpless on March 6, 2012
SQL Server 2012 – RTM
REDMOND, Wash. — March 6, 2012 — Microsoft Corp. today announced that the latest version of the world’s most widely deployed data platform, Microsoft SQL Server 2012, has released to manufacturing. SQL Server 2012 helps address the challenges of increasing data volumes by rapidly turning data into actionable business insights. Expanding on Microsoft’s commitment to help customers manage any data, regardless of size, both on-premises and in the cloud, the company today also disclosed additional details regarding its plans to release an Apache Hadoop-based service for Windows Azure.
“Data is being generated faster than ever before, and organizations need a way to process and analyze all that data,” said Ted Kummert, corporate vice president at Microsoft. “Whatever the type or size of data, SQL Server 2012 delivers the platform and familiar tools to manage data, generate actionable insights and help drive business impact.”
Full Article: http://www.microsoft.com/Presspass/press/2012/mar12/03-06SQLServer12PR.mspx