Scripts for Using ASCMD for Stress Testing at http://www.codeplex.com/SQLSrvAnalysisSrvcs
This project on Codeplex includes two scripts for using ASCMD for stress testing. One script is optimized for serially executing a stream of queries and the second script is for executing multiple streams of queries in parallel. You can control the number of queries, the number of streams, and the think time between queries.
About CarlRabeler
Carl is a Senior Program Manager on the SQL Server Customer Advisory Team, and is an Extended Customer Program Manager with the Reporting Services and Integration Services product groups. Carl works closely with internal and external customers to develop solutions and validate SQL Server business intelligence best practices for working with large scale and complex BI solutions. Carl has worked with Microsoft SQL Server for over 13 years as a consultant, mentor, writer, speaker and trainer. Carl has written several SQL Server books and numerous technical white papers, has presented at many SQL Server conferences, and has provided mentoring and consulting services for numerous companies around the world.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
