Browse by Tags

• cpu
• developer tools
• Performance
• Query Tuning
• SQLCLR
• threads
• T-SQL

• CloudSeeder: CLR Stored Procedures For Creating CPU Pressure

  Sometimes, in the interest of testing various scenarios that your server might encounter, it's useful to be able to quickly simulate some condition or another. I/O, memory, CPU pressure, and so on. This latter one is something I've been playing with a Read More... Posted Tuesday, October 23, 2012 4:49 PM by Adam Machanic | 0 Comments Filed under: Testing, SQLCLR, threads, cpu Attachment(s): cloudSeeder.sql

• Announcing SQLQueryStress: A simple query load tool

  On October 20, 2004 -- two years ago -- I announced that I was considering writing my own query load testing tool . Clearly, my follow through on this promise has been incredibly delayed. But all is not lost, and I'm happy to report that I am true to Read More... Posted Saturday, October 21, 2006 1:29 AM by Adam Machanic | 1 Comments Filed under: Performance, Query Tuning, Testing

• Introducing: TSQLMacro

  I am pleased to announce the official introduction of the TSQLMacro framework , version 0.5 (prebeta-1). This version is functionally complete based on the initial design spec , features are stable, and I am not currently aware of any bugs. So what is Read More... Posted Wednesday, July 12, 2006 10:37 PM by Adam Machanic | 4 Comments Filed under: T-SQL, Testing, developer tools

• Introducing: TSQLAssert

  Yes, yet another introduction (although there was almost zero reaction to yesterday's introduction ). Today, I introduce the first thing built on top of TSQLMacro . I proudly present the TSQLAssert debug assertion framework ! For those of you who've worked Read More... Posted Wednesday, July 12, 2006 10:37 PM by Adam Machanic | 0 Comments Filed under: T-SQL, Testing, developer tools