CA_SLA_ComplianceCheck

Double click on the CA Setup script below then Copy, Paste into a new SQL Agent Job Step.

Copy / Paste only works with Chrome or newer versions of Internet Explorer, a line feed/character return problem corrupts the T-SQL if copied using Internet Explorer 8 or lower.


-------------------------------
-- CPU & IO - Lightweight Synthetic Transactions
-------------------------------
USE CellularAutomation
GO

-- SQL Server 2008 / 2012 - SLA Synthetic Transaction IO Performance
DECLARE @RC int;
DECLARE @TestCase varchar(50)  = 'SLA Synthetic Transaction - SQL IO' ;

EXECUTE @RC = [dbo].[CA_LoadTestExecute] 
   @Batches_IO = 1
  ,@Batches_CPU = 0
  ,@NewPatterns = 100
  ,@TestCase = @TestCase
  ,@StressLevel = 3
GO

--  SQL Server 2008 / 2012 - SLA Synthetic Transaction CPU Performance
DECLARE @RC int;
DECLARE @TestCase varchar(50) = 'SLA Synthetic Transaction - SQL CPU';

EXECUTE @RC = [dbo].[CA_LoadTestExecute] 
   @Batches_IO = 0
  ,@Batches_CPU = 1
  ,@NewPatterns = 200
  ,@TestCase = @TestCase
  ,@StressLevel = 1
GO

-- Tidy preparation for next check, start empty for query plan reuse
TRUNCATE TABLE dbo.GridReference
TRUNCATE TABLE dbo.Merkle
GO


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: