CloudSeeder: CLR Stored Procedures For Creating CPU Pressure

Posted by Adam Machanic on SQL Blog See other posts from SQL Blog or by Adam Machanic
Published on Tue, 23 Oct 2012 19:49:00 GMT Indexed on 2012/10/23 23:11 UTC
Read the original article Hit count: 250

Filed under:

cpu

|

sqlclr

|

testing

|

threads

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 lot recently. CPU pressure in SQL Server creates all sorts of interesting side-effects , such as exacerbating waits and making various other conditions much easier to reproduce. In order to make this simpler, I've created the attached CLR library. This...(read more)

© SQL Blog or respective owner

Related posts about cpu

Speedstep and Intel x5570?

as seen on Server Fault - Search for 'Server Fault'
Hi, My new server has 2 x X5570 CPUs. Now here is the output of grep -i hz /proc/cpuinfo model name : Intel(R) Xeon(R) CPU X5570 @ 2.93GHz cpu MHz : 1600.231 model name : Intel(R) Xeon(R) CPU X5570 @ 2.93GHz cpu MHz : 1600.231 model name : Intel(R) Xeon(R) CPU … >>> More
VMware ESXi - varying CPU time (CPU reservation)

as seen on Server Fault - Search for 'Server Fault'
Hello! I'm running FreeBSD 7.2 under VMware ESXi 3.5. Host has 2 physical CPUs and the BSD box is currently the only running VM. Only one virtual CPU is assigned to the VM. When measuring CPU time of a specific program, I get very different results from time to time. Processor usage is reported… >>> More
How to calculate CPU % based on raw CPU ticks in SNMP

as seen on Server Fault - Search for 'Server Fault'
According to http://net-snmp.sourceforge.net/docs/mibs/ucdavis.html#scalar_notcurrent ssCpuUser, ssCpuSystem, ssCpuIdle, etc are deprecated in favor of the raw variants (ssCpuRawUser, etc). The former values (which don't cover things like nice, wait, kernel, interrupt, etc) returned a percentage… >>> More
disparity between `top`'s given CPU % and process CPU usage total

as seen on Super User - Search for 'Super User'
I've noticed that there are sometimes (large) differences between the reported total CPU usage and a summation of the per-process CPU utilization given by apps like top and wmtop. As an example: I recently ran a git filter-branch --index-filter on a fairly large repo, with the index-filter command… >>> More
How to read oom-killer syslog messages?

as seen on Server Fault - Search for 'Server Fault'
I have a Ubuntu 12.04 server which sometimes dies completely - no SSH, no ping, nothing until it is physically rebooted. After the reboot, I see in syslog that the oom-killer killed, well, pretty much everything. There's a lot of detailed memory usage information in them. How do I read these logs… >>> More

Related posts about sqlclr

Visual Studio 2010 and SQLCLR: Some Good, Some Bad

as seen on SQL Blog - Search for 'SQL Blog'
This past week I've been trying out Visual Studio 2010 for SQLCLR development. Verdict: A couple of nice things, a couple not so nice. In the interest of keeping things somewhat positive around here, we'll start with the good stuff : Pre-deployment and post-deployment scripts are built in. This is… >>> More
SQLCLR and DateTime2

as seen on Stack Overflow - Search for 'Stack Overflow'
Using SQL Server 2008, Visual Studio 2005, .net 2.0 with SP2 (has support for new SQL Server 2008 data types). I'm trying to write an SQLCLR function that takes a DateTime2 as input and returns another DateTime2. e.g. : using System; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; namespace… >>> More
SQLCLR using the wrong version of the .NET Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
During a recent restart of our development server the SQL Server started using .NET 4.0 for the SQLCLR. This means that nothing using the CLR in SQL works, or at least that's my understanding by reading these sources: http://software.intel.com/en-us/blogs/2009/10/16/sql-server-2008-sqlclr-net-framework-version/ www… >>> More
SQL Server 2008 SQLCLR Issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQLCLR that was originally running on SQL Server 2005 DB. I have since rebuilt the CLR to run on SQL Server 2008. The CLR requires a reference to WindowsBase.dll. I added WindowsBase.dll as an assembly to the SQL Server 2008 DB. When I try to use the rebuilt CLR I get the message Could… >>> More
SQLCLR function to return free space for all drives on a server

as seen on SQL Server Central - Search for 'SQL Server Central'
When looking for impending problems due to lack of disk space it's necessary to know how much space is available on each drive. There have been other tips written about how to do this, but in this tip I show you a way this can be done using SQLCLR. >>> More