Tuco Benedicto Pacífico Juan María Ramírez (en_ki) wrote,
Tuco Benedicto Pacífico Juan María Ramírez
en_ki

Dare To Be Stupid

Microsoft SQL Server has a tool within Enterprise Manager for looking at open connections to the database, what they're doing, how much of each sort of resource they are using, and so on.

As you would expect, you can sort by each of the columns; that way you can quickly answer questions like "which of these (hundreds of) processes is accessing which database?", "which is using the most RAM?", and so on... well, sort of.

You see, it sorts every field lexicographically: in dictionary order. So if you are sorting in descending order by KB of RAM used, you might see (to pick an example purely at random from the screen that happens to be in front of my eyeballs right now):

99, 92, 9, ..., 9, 88, 87, 83, 8184, 8, 8, 8, 79, 77, 77, 752, ...

Quick: find the memory hog!

FOR FUCK'S SAKE PEOPLE. It would be better not to sort at all.

Does it ever occur to anyone at Microsoft1 that some day, someone, somewhere, might be trying to use their products?

1 This rant is about Microsoft, but Microsoft is actually only the second worst company in the world. BMC is the worst. Thank God I declined to work there ages ago; I can't begin to imagine what sort of troll writes this shit.
Subscribe
  • Post a new comment

    Error

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 4 comments