HP I/O Accellerator Card – Test
This week i had the honor to test a G2-Series HP I/O-Accellerator Card.
Installation and Post-Configuration of the card is very easy. So you could go ahead immediately with testing these Hot Stuff.
We configured the card to 50% Performance, so we loosed 50% of the available space on the I/O-Card. But for our reasons, to put the TEMPDB of MS SQL-Server 2008 R2 and an Archive log of an ERP-System database on it, shoud this be space enough.
So here are the test results. I don’t wan’t to comment to much. Look at the results. They are self explaining.
Random Read Test (SQLIO – 8 Threads, 16 Outstanding Requests, 64 Block read)
SQLIO -kR -t8 -s3600 -dF -o16 -frandom -b64 -BH -LS testfile_read.dat
sqlio v1.5.SG
using system counter for latency timings, 2050878 counts per second
8 threads reading for 3600 secs from file F:testfile_read.dat
using 64KB random IOs
enabling multiple I/Os per thread with 16 outstanding
buffering set to use hardware disk cache (but not file cache)
using current size: 51200 MB for file: F:testfile_read.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 21116.24
MBs/sec: 1319.76
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 263
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 0 12 15 13 11 9 8 6 5 4 3 3 2 2 1 1 1 1 0 0 0 0 0 0 0
Testing Random IO-Reads
SQLIO -kR -t8 -s3600 -dF -o16 -frandom -b64 -BH -LS testfile_read.dat
sqlio v1.5.SG
using system counter for latency timings, 2050878 counts per second
8 threads reading for 3600 secs from file F:testfile_read.dat
using 64KB random IOs
enabling multiple I/Os per thread with 16 outstanding
buffering set to use hardware disk cache (but not file cache)
using current size: 51200 MB for file: F:testfile_read.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 20267.48
MBs/sec: 1266.71
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 186
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 1 12 15 13 10 9 7 6 5 4 4 3 2 2 2 1 1 1 1 0 0 0 0 0 1
Testing Random IO-Reads
SQLIO -kR -t8 -s3600 -dF -o16 -frandom -b64 -BH -LS testfile_read.dat
sqlio v1.5.SG
using system counter for latency timings, 2050878 counts per second
8 threads reading for 3600 secs from file F:testfile_read.dat
using 64KB random IOs
enabling multiple I/Os per thread with 16 outstanding
buffering set to use hardware disk cache (but not file cache)
using current size: 51200 MB for file: F:testfile_read.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 21082.65
MBs/sec: 1317.66
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 5
Max_Latency(ms): 203
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 0 12 15 13 11 9 8 6 5 4 4 3 2 2 1 1 1 1 0 0 0 0 0 0 0
Sequential Write Test (SQLIO)
Creating Testfile...
sqlio v1.5.SG
using system counter for latency timings, 2050878 counts per second
parameter file used: param.txt
file F:\testfile_read.dat with 8 threads (0-7) using mask 0x0 (0)
8 threads writing for 5 secs to file F:\testfile_read.dat
using 64KB random IOs
enabling multiple I/Os per thread with 1 outstanding
buffering set to use hardware disk cache (but not file cache)
size of file F:\testfile_read.dat needs to be: 53687091200 bytes
current file size: 0 bytes
need to expand by: 53687091200 bytes
expanding F:\testfile_read.dat ... done.
using specified size: 51200 MB for file: F:\testfile_read.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 10258.38
MBs/sec: 641.14
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 7
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 87 7 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Enumerate Database-Role Membership
Hey Guy’s
here i am with my 1st SQL-Server Post!
If you want to know the membership of a database role, to what other database roles the role
belongs to, i have a good satatement for you.
SELECT dbrole1.name AS dbrole1_name , dbrole1.principal_id , dbrm.role_principal_id , dbrole2.name AS dbrole2_name FROM sys.database_principals AS dbrole1 JOIN sys.database_role_members AS dbrm ON dbrm.member_principal_id = dbrole1.principal_id JOIN sys.database_principals AS dbrole2 ON dbrole2.principal_id = dbrm.role_principal_id WHERE dbrole1.name LIKE '<db-role name>' ORDER BY dbrole1.name ASC
Facebook – Behind the scenes
I always recommend colleagues to read and watch the thread on sysadminslive.com about the Facebook IT Mangement and Operations strategy.
Because the using good tools and ideas to observe there system.
Take a look at yourself: http://www.sysadminslife.com/linux/facebook-ein-blick-hinter-die-kulissen-und-in-das-komplexe-system
Windows Terminalserver Farm & 8dot3 names
Hey Folks!
currently i’m on the way to deploy a Windows Server 2008 R2 terminal server farm. One server is already up and running productive and the other is one step before going online. I work a lot of with GPO’s and user roaming profiles, to ensure to have excatly the same configuration on the new server for all users. Also i use control panel restrictions to display only neccessary .CPL’s to the user.
And one special control panel addin, what is shipped with the MS Office suite ML32CFG.CPL (responsilbe for configuring MS Outlook MAPI Profile), i discovered how important it is, to ensure that applications have to be installed in the same order as on the other terminal servers. Why, you may ask….because, of the 8dot3-names (8.3) and the windows internal file/path handling. In some cases the OS calls an an application it tries to use the 8dot3 path / name.
The control panel addin on the new server was registered successfully during the installation, and i could open it. But if i tried to open the CPL with my test user, what is already using the saved roaming profile, the addin would not open. Also the icon in the control panel window was different against to the other server.
So what happend? With Sysinternals Process Moinitor (PROCMON.EXE) I did a little bit research on both servers, and found out that the 8dot3 name of the MS Office path between both servers is different because i didn’t keep in mind the order, how i installed the applications on the new TS.
Server 1: (C:PROGRA~2\MICROS~1\Office12\MLCFG32.CPL)
Server 2: (C:PROGRA~2\MICROS~2\Office12\MLCFG32.CPL)
To solve the problem, i had no chance uninstall the application what occupies the 8dot3 name, uninstall office and reinstall office and the other application again. After reinstalling MS Office suite, the right 8dot3 name was assigned tho the new installation.
Soluto – Anti Frustration Software
Soluto (www.soluto.com)
It’s an Awesome Tool, to Speed Up Your System Boot, Fix System Slowdowns
Sound’s very interesting and i’ll give them a try.
found via Lifehacker (http://tinyurl.com/26py4s2)…
Group Policy Search
Discovered via Daniel Melanchton’s Technet Blog
This is really a nice Tool to find existing Group Policies easily. The Group Policy Search
Thank’s Daniel for that helpful information.
Automate Logins with Keepass and Firefox
A long time ago, but now it’s here!
everyone knows it’s very annoing if you have to login to multiple websites during work days. It would be much easier to have a tool tool, what helps us to automate the login process to websites like Amazon, Facebook, Microsoft, Onlinebanking, etc.., where i am registered to. That would safe time and increases workflow and you don’t need to consider about passowrds anymore. Before this article i used a very simple tool to manage my passwords. I also heard and tested Keepass in the past, but it brought no advantage on my workflow.
Now I found this tool Read more…
PDFmyURL Service
I found a cool service on the Internet, which converts every URL into a PDF.
Erase your Web 2.0 identity (suicidemachine.org)
I found a cool link via lifehacker.com
Whoever want’s to erase his Web 2.o identity, properly and for ever, the suicidmachine will help you to erase your tracks on the web!







