Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

troubleshooting sql server 2000 slowness Expand / Collapse
Author
Message
Posted Saturday, March 30, 2013 10:24 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:18 AM
Points: 90, Visits: 135
Hi for few days i am going to work at client side which has sql server 2000. I am knew to it show just want to know where to look for helps .

I mean suppose i want to know which query are executing at present then where to look . dbbc inputbuffer does not shows complete query then where to look.

I want to know how much time it would require to complete a database backup/restore then which queries to use.

some faster way to know fragmenatation in table

Thanks and regards
Anoop

Post #1437269
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse