0
votes
2answers
117 views

Diagnosing intranet performance issues

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. ...
3
votes
2answers
751 views

SQL Server 2000, large transaction log, almost empty, performance issue?

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 ...
0
votes
3answers
100 views

Top queryes in SQL Server 2000

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?
2
votes
2answers
795 views

SQL 2000 - WAITSTATS: CXPACKET query

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 ...