[sky-blog]

 wie teste ich mal die Performance meiner Maschine?

--IO write Messen mit 5GB auf LOG Partition

USE master

declare @StartZeit as datetime, @EndZeit as datetime, @Speed as float

--Temporäre DB erstellen (Files sind automatisch in den Default Locations)

CREATE DATABASE TEMP_TEST;

select @StartZeit = GETDATE()

--TempFile aufblasen

ALTER DATABASE [TEMP_TEST] MODIFY FILE ( NAME = N'TEMP_TEST_log', SIZE = 5120MB )

select @EndZeit = GETDATE()

--Temporäre DB wieder löschen

DROP DATABASE [TEMP_TEST]

select @speed = 5120 /DATEDIFF(SECOND,@StartZeit,@EndZeit)

select 5120 as MB, DATEDIFF(SECOND,@StartZeit,@EndZeit) as Seconds, @speed as [MB/s] 

, Speed = case  

              when @speed < 40 then 'Floppy-Disk'  

              when @speed < 80 then 'USB-Stick'  

              when @speed < 100 then 'Hobby' 

              when @speed < 120 then 'Naja' 

              when @speed < 150 then 'benutzbar' 

              when @speed < 180 then 'ganz OK' 

              when @speed < 250 then 'flott' 

              when @speed < 300 then 'Pro-Level' 

              when @speed < 390 then 'nice!'

              when @speed < 400 then 'Referenz Datacenter CH'

              when @speed < 450 then 'Outstanding'

              when @speed >= 450 then 'schick ein Kasten Bier an dein DB Hoster!' 

END

GO