Monthly Archives: March 2012

SQL Server 2012 – Performance Dashboard Reports (Available)

Posted by dpless on March 22, 2012 None comments

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
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)
  • Blocking
  • 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.

Tampa Bay SQL Server User’s Group meeting – March 20th @ 6:00pm

Posted by dpless on March 15, 2012 None comments

Tampa Bay SQL Server User’s Group meeting – March 20th @ 6:00pm (6:30pm official start)

Meeting Location:
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 pshaw1129@live.com

Description:
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
2012.

Microsoft Releases SQL Server 2012 to Help Customers Manage “Any Data, Any Size, Anywhere”

Posted by dpless on March 6, 2012 None comments

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