Pushing the boundaries, going forward

Ever since I remember myself, when I was 3 or so, I remember having this big fat constantly hanging question “And what if I try this?“.

The question itself is simple, but it is so alluring that it is impossible to resist.

And it does not come cheap: I have broken many toys (as a kid) and

Continue reading […] Pushing the boundaries, going forward […]

 

How come the Hourglass? Why database applications slow down

A new article of mine is out!

This time I write about the meaning of “my database is slow” and what hidden secrets database contain. I.e. databases are never a single player in the game of performance.

Here is the article: How come the Hourglass? Why database applications slow down.

 

Disk and mount points space and properties

Here is a piece of code which gives a good idea about the drives on your system, and also about the mountpoints.

gwmi -computername¬†Enter_Server_Name win32_volume|where-object {$_.filesystem -match “ntfs”}|ft name,Availability,BlockSize,Compressed,DirtyBitSet,IndexingEnabled,Label,LastErrorCode,PowerManagementCapabilities,Status,@{Name=’CapacityMB’;Expression={$_.Capacity/1MB} },@{Name=’FreeSpaceMB’;Expression={$_.FreeSpace/1MB} }

Availability – describes the availability and the status of the device. (For example, Offline)
BlockSize – Size in bytes of the blocks in this storage extent.
DirtyBitSet –

Continue reading […] Disk and mount points space and properties […]