Check Out the SQL Server Playback Program

Microsoft announced a new SQL Server quality assurance program last year called the SQL Server Playback Program, which I wrote about in my SQL Server Magazine UPDATE article "Participate in the SQL Server Playback Program!" (which is available online at the URL at the end of this paragraph). Microsoft is always looking for customers with interesting application workloads that fit the program criteria, and the company is now actively seeking a new round of SQL Server Playback customers to get ready for the Yukon rollout in 2003. So, I'd like to revisit the unique opportunity this program presents for the right SQL Server customers.

http://www.sqlmag.com/articles/index.cfm?articleid=21372

What will the SQL Server Playback Program do for you? Participation in the program:

Interested? If so, keep reading!

You've probably used SQL Server Profiler to examine the commands your SQL Server is processing. However, you might not realize that Profiler also provides a foundation for "playing back" a trace file later. Profiler lets you create repeatable workloads that you can run again and again, tweaking certain configuration parameters or indexes as you go. Microsoft uses this capability to create robust test suites based on live customer applications. SQL Server 2000 is very reliable, but the SQL Server test team is always looking for ways to push SQL Server to the next level, and the best way to do that is to benchmark the performance and behavior of real applications.

Microsoft needs your help to find the busiest servers, the largest databases, and the most complex queries the team can use to stress SQL Server to the limit. In the Microsoft labs, the team will replay these workloads on future versions of SQL Server to stress the server while applying concurrent workloads. The team will look for reliability and performance problems. If Microsoft accepts your workload for testing, you'll have extra assurance that your database code will work and perform marvelously with the next SQL Server release.

Microsoft will require a few commitments from you if you participate in the Playback Program. You must provide a backup and Profiler trace of your production database and workload. Microsoft will provide nondisclosure agreements (NDAs) to secure your data for use only in this program. The engineers who manage this program have told me that the biggest hurdle some customers have to cross before deciding to join the program is allaying their own concerns about how well Microsoft will guard their data and application code. Speaking about security practices in the SQL Server Playback Program, a Microsoft representative said, "Security is naturally of utmost importance. Rest assured that customer databases will be used only by the SQL [Server] team for testing purposes and will not be distributed to anyone else whatsoever, for any purpose. All playbacks are held on a secure storage server where only the SQL [Server] team has access. Furthermore, all media (tapes, CDs, etc.) are stored in a locked cabinet room. We can also provide two-way signed nondisclosure agreements upon request, if it eases your concern."

What types of workloads will Microsoft select? All Playback Program submissions must be from SQL Server 2000 on production servers. The team is looking for Profiler traces that include some of the following characteristics (but your application doesn't have to include all these items):

If you want to participate in the SQL Server Playback Program, email your company name, company contact, email address, and phone number to [email protected]. Microsoft will review your application and respond if you qualify. Also include

Microsoft will accept submissions for the current round of SQL Server Playback testing until August 31. In addition to the technical benefits you'll get if you participate, you'll receive a cool SQL Server polo shirt, and a Microsoft representative told me that workloads that "help us find issues" will earn "a little something as a reward."

Microsoft announced a new SQL Server quality assurance program last year called the SQL Server Playback Program, which I wrote about in my SQL Server Magazine UPDATE article "Participate in the SQL Server Playback Program!" (which is available online at the URL at the end of this paragraph). Microsoft is always looking for customers with interesting application workloads that fit the program criteria, and the company is now actively seeking a new round of SQL Server Playback customers to get ready for the Yukon rollout in 2003. So, I'd like to revisit the unique opportunity this program presents for the right SQL Server customers.

http://www.sqlmag.com/articles/index.cfm?articleid=21372

What will the SQL Server Playback Program do for you? Participation in the program:

Interested? If so, keep reading!

You've probably used SQL Server Profiler to examine the commands your SQL Server is processing. However, you might not realize that Profiler also provides a foundation for "playing back" a trace file later. Profiler lets you create repeatable workloads that you can run again and again, tweaking certain configuration parameters or indexes as you go. Microsoft uses this capability to create robust test suites based on live customer applications. SQL Server 2000 is very reliable, but the SQL Server test team is always looking for ways to push SQL Server to the next level, and the best way to do that is to benchmark the performance and behavior of real applications.

Microsoft needs your help to find the busiest servers, the largest databases, and the most complex queries the team can use to stress SQL Server to the limit. In the Microsoft labs, the team will replay these workloads on future versions of SQL Server to stress the server while applying concurrent workloads. The team will look for reliability and performance problems. If Microsoft accepts your workload for testing, you'll have extra assurance that your database code will work and perform marvelously with the next SQL Server release.

Microsoft will require a few commitments from you if you participate in the Playback Program. You must provide a backup and Profiler trace of your production database and workload. Microsoft will provide nondisclosure agreements (NDAs) to secure your data for use only in this program. The engineers who manage this program have told me that the biggest hurdle some customers have to cross before deciding to join the program is allaying their own concerns about how well Microsoft will guard their data and application code. Speaking about security practices in the SQL Server Playback Program, a Microsoft representative said, "Security is naturally of utmost importance. Rest assured that customer databases will be used only by the SQL [Server] team for testing purposes and will not be distributed to anyone else whatsoever, for any purpose. All playbacks are held on a secure storage server where only the SQL [Server] team has access. Furthermore, all media (tapes, CDs, etc.) are stored in a locked cabinet room. We can also provide two-way signed nondisclosure agreements upon request, if it eases your concern."

What types of workloads will Microsoft select? All Playback Program submissions must be from SQL Server 2000 on production servers. The team is looking for Profiler traces that include some of the following characteristics (but your application doesn't have to include all these items):

If you want to participate in the SQL Server Playback Program, email your company name, company contact, email address, and phone number to [email protected]. Microsoft will review your application and respond if you qualify. Also include

Microsoft will accept submissions for the current round of SQL Server Playback testing until August 31. In addition to the technical benefits you'll get if you participate, you'll receive a cool SQL Server polo shirt, and a Microsoft representative told me that workloads that "help us find issues" will earn "a little something as a reward."