check master..sysprocesses table , you can filter based on your criteria based on session status /cputime /diskIO / OpenTarn....

is that what u r looking for?

what kinda bug microsoft confirmed??

is it specific to a functionality? recreatable??

Did u tried update statistics for the tables involved in this problem statement? earlier by mistake i said dbcc updateusage....

based on my experiences this is the one thing which resolves...

script ut the database from SSMS and then use sqlcmd to run it from command line....u can customise script to accept various parameters from sqlcmd

foriegn keys are good to have as it ensure data entigrity....though it will afeect performance slightly....

I normally put it while in developement, but then go ahead and remove it once...

agree with allen...after restoring 2000 db to 2005 ....its must to reorganize stats...

use dbcc updateusage.....

check BOL for charstring and substring functions.....

for sql 2005 adding space is not taking time like sql 2000. though if you know it would increase by 1 GB every day you should manually increase the space...

Still open...not able to figure out with this tool....

anymore ideas or just wait for sql server restart?

Thanks Phillip....I downloaded and tried...seems quite a tool to handle many things...

tried running...

Thanks for your inputs...

I did tried to find out which is that process...i think the name should be svchost....though there are serveral svchosts are running

I did think about "process...

Tried but hard luck....this command says........

"DBCC cannot free the DLL "xp_availablemedia.dll". The DLL is...

wow...looks like it will work....will try and confirm...

I prefer to see what my I/O requirement to judge raid requirement...here are my rules

Rule 1: OS and data Log always remain on Raid1 or if having luxury will go...

This is really great stuff....and Terminal service stuff though i used to do it from command prompt but this is very handy

great utilities.....i believe this article should be promoted every...