I'm attempting to figure out why our intranet is having performance issues. From some basic troubleshooting, I'm leaning towards the issue being our SQL server, which is hosted on a separate server. ...
For a company that I have been helping troubleshoot their database. In SQL Server 2000, database is about 120 gig. Something caused the transaction log to grow MUCH larger than normal to over 100 ...
I'm looking for a way to identify top resource consuming queries in SQL Server 2000. Is thre a way to do that other than Sql profiler or a third party monitoring tool like Quest?
Platform: SQL 2000 Enterprise with SP4, running on Windows 2003 Enterprise, 8 cores, 8GB RAM, and internal (!) storage. Databases are roughly 100GB in total. Scenario: The waitstats are heavily ...