[EMAIL PROTECTED] wrote: > Hi everybody, we have a MS-SQL-7 server piking (+ plateaus) to 100% CPU. > > It is caused by mssqlserver.exe. How can we find out, what database access is > causing this, > since I have about 20 DBs running on them ? All DBs are powering > ColdFusion shop-systems.
Use Enterprise Manager... go to your database -> Management -> Current Activity -> Process Info That'll show you current queries that are running and stuff like that... it can be ver helpful for debugging issues. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235852 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54