Archive for August, 2010

Memory OOM condition–SQL Server August 28th, 2010

Vinod Kumar

Many a times there are needs to figure out if really there are instances where SQL Server components were raising Out-Of-Memory conditions. A quick way to keep track of this is to track the ring_buffers table. Typically you will use something like this:

   1:  SELECT
   2:      record 
   3:  FROM
   4:      sys.dm_os_ring_buffers 
   5:  WHERE
   6:      ring_buffer_type = 'RING_BUFFER_OOM'

Obviously a row here means you do have memory pressures that were being forced. For some explanation on the various values ring_buffers might send, see this blog post from PSS which gives you some starters. I highly recommend reading this whitepaper in your leisure for Performance Troubleshooting which also talks about some of the cool things ring_buffers expose when you start working with SQL Server.

Happy weekend Smile

Continue reading...


New AppFabric WCF DataService Template (C#) August 25th, 2010

Vinod Kumar

Today marks the availability of a new Feature Builder based template for Windows Server AppFabric and WCF Data Services

  • WCF Data Services enables the creation and consumption of OData services for the web (formerly known as ADO.NET Data Services).
  • Windows Server AppFabric provides tools for managing and monitoring your web services and workflows.

The AppFabric WCF DataService template brings these two products together providing the following features:

  • Monitor the queries to your service across multiple servers with AppFabric Monitoring
  • Properly report errors to Windows Server AppFabric (WCF Data Service errors are not recognized by AppFabric otherwise)
  • Eliminate the .svc extension from the URI by using routing
  • Provide a simple HTML page for invoking the service with or without the .svc extension
Get It

If you have the guidance and the template along together in one package you simply add a new AppFabric WCF Data Service to your project and everything you need to know shows up right in Visual Studio – how cool is that?


So go download this template today and give it a go …

Continue reading...


Microsoft Assessment and Planning Toolkit 5.0 now available August 3rd, 2010

Vinod Kumar

The new Microsoft Assessment and Planning (MAP) Toolkit 5.0 is now available for download! MAP 5.0 is an agentless tool designed to simplify and streamline the IT infrastructure planning process across multiple scenarios through network-wide automated discovery and assessments. This Solution Accelerator performs an inventory of heterogeneous server environments and provides you with usage information for servers in the Core CAL Suite and SQL Server, SQL Server 2008 discovery and assessment for consolidation, Windows 2000 Server migration assessment, and a readiness assessment for the most widely used Microsoft technologies—now including Office 2010.

Is your organization spending valuable resources planning its IT infrastructure? Download the MAP Toolkit 5.0, and let this tool do the heavy lifting for a wide variety of your IT planning projects.

Next steps:

MAP Toolkit 5.0 Key Features and Benefits

What’s new with MAP Toolkit 5.0?

  • Heterogeneous server environment inventory
  • Software usage tracking for Windows Server, SharePoint Server, System Center Configuration Manager, Exchange Server, and SQL Server
  • Microsoft Office 2010 readiness assessment
  • SQL Server discovery and assessment for consolidation
  • Windows 2000 Server migration assessment

The MAP Toolkit 5.0 includes the following new features:

Heterogeneous Server Environment Inventory: Know what’s in your IT environment. The Microsoft Assessment and Planning (MAP) Toolkit performs a network inventory of IT assets remotely without the use of agents, identifying heterogeneous server environments consisting of Windows Server and Linux operating systems, including those running in a virtual environment. MAP 5.0 also automates the discovery of Linux-powered LAMP stacks.

Software Usage Tracker: Right-size your IT environment with MAP Toolkit 5.0, and simplify your software license management and compliance processes. MAP 5.0’s new usage tracking feature provides consistent software usage reports for key Microsoft server products: Windows Server, SharePoint Server, System Center Configuration Manager, Exchange Server, and SQL Server. Run updated reports whenever you need to accurately assess current software usage and client access history in your environment. This reduces time and administrative costs for managing your server and client access licenses (CALs) and helps you to streamline the management of your software assets.

Microsoft Office 2010 Readiness Assessment: Streamline your migration to Office 2010 with MAP 5.0’s hardware compatibility proposal document. The MAP Toolkit provides readiness details and specifics of your IT infrastructure inventory, including hardware and OS requirements and upgrade recommendations for planning a seamless deployment of Office 2010. The actionable recommendations and assessments presented shorten the time it takes to plan your Office 2010 migration and prepares your IT environment for Office 2010 deployment and migration scenarios.

Database Discovery for SQL Server Consolidation: MAP 5.0’s new database discovery feature gives you the information you need to optimize your database resources and investments. MAP helps you simplify database administration and provides wide-ranging details of databases and server instances—information you can utilize for consolidation. Use the MAP Toolkit’s proposals to better utilize hardware and database resources, reduce administrative costs, and streamline your software licensing needs—all essential for cost-effective IT planning and operations.

Windows 2000 Server Migration Assessment: As support for Windows 2000 Server ends soon, MAP 5.0’s Migration Assessment feature helps you prepare for migration to Windows Server 2008 R2 by assessing the Windows 2000 Server environment and legacy workloads in the form of proposals and reports. The MAP Toolkit’s actionable recommendations help you to understand the potential business impact of maintaining legacy workloads and the benefits of migrating to the robust Windows Server 2008 R2 environment. With migration to Windows Server 2008 R2, you’ll be able to utilize the increased IT flexibility and efficiency from such technologies as Hyper-V and Remote Desktop Services, as well as tap into power-savings features to decrease TCO.

Continue reading...