Roy Ashbrook

let go or be dragged
posts - 197, comments - 29, trackbacks - 8

September 2010 Entries

which pid is which in iis and how much memory are they using

You can do this lots of ways. Here's a quick way from the command line: iisapp tasklist /FI "IMAGENAME eq w3wp.exe"  then just line up the PID numbers.

posted @ Tuesday, September 14, 2010 5:40 PM | Feedback (0) |

Normal and abnormal ways to display the logical scan fragmentation in sql database

So the way I am getting this data is just normal dbcc showcontig in a db. But for some reason, when I saw the output of dbcc showcontig today, I just decided I *had* to parse it with the command line. /sigh I just wanted the logical scan fragmentation. So this is, in part, the output. Profile_Lookup 99 MSSCrawledProperties 96 MSSManagedProperties 66 UserProfileEventLog 50 UserColleagues 40 UserMemberships 85 UserSites 66 MembershipRecursive 73 MembershipNonRecursive 1 Etc etc etc etc  To do this I just did a simple for loop with a call out to a …. I forget what these things are even called since no one uses them anymore or cares....

posted @ Monday, September 13, 2010 7:17 PM | Feedback (0) |

Powered by: