Showing Tag: "io" (Show all posts)

Thats your database, not your Toyota stalling!

Posted by John Trumbul on Friday, November 2, 2012,
Turn the key, hear the engine catch go to put it in drive and... shit Darn it golly gee a stall. This is NOT just for cars anymore. One of the biggest performance issue indicators I have ever used in practice to check for DB issues has been an IO Stall test metric. In days of old, you know when 16 bit gaming consoles made you the man if you had one, and Mortal Kombat was THE GAME to play.. (still is now by the way if anyone is on PSN and wants to take a beating ProphetDE come find me) I had n...
Continue reading ...

Dumping IO Stats to powershell, and WTF did he just say.

Posted by John Trumbul on Sunday, October 7, 2012,
Hello All,

A 2 part post this month, i guess i finally removed head from arse and got around to posting updates. First a super useful query for IO stats of log and data files. Please note these are at file level. This may exist already and im sure there are better ways to do this, but since i have been going through a ton of logs and data files at work recently, i figured it was worth a post.

DB_NAME(tblFileStat.database_id) AS databaseName ,
tblFileStat.file_id ,tblMasterFile.phy...
Continue reading ...

Quick but useful Index Fragmentation

Posted by John Trumbul on Friday, July 13, 2012, In : SQL Scripts 
Since I happen to be using this right now, I figure i would throw it up. Table not performing the way you would like? Perhaps the index is fragmented to high hell. Usinf this in combination with a Reorganize and Rebuild script should help a great deal.

SELECT ps.database_id, ps.OBJECT_ID,
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS ps
AND ps.index_id = b.index...
Continue reading ...

Good News and Another Apology

Posted by John Trumbul on Wednesday, July 11, 2012,
Hello All, for the thousandth time I apologize for the lack of updates. However this time I actually have good reason. The company I currently work for now PlayStudios - is launching our game soon. I believe July 17th is the release date to be exact. More info to follow (for real this time).

In other news I have again been nominated for the Red Gate Exceptional DBA award. I know people can sign up and nominate themselves and if I had done that I would not announce it. Sinc...
Continue reading ...

This free website was made using Yola.

No HTML skills required. Build your website in minutes.

Go to and sign up today!

Make a free website with Yola