Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

We run JD Edwards' One World here on an NT 4 sql server. It's a pretty decent server but lately it's been running like a dog.<BR><BR>It's a 4-way 450mhz Xeon(2mb cache) machine with 4gigs of ram. All ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Redgate, the Database DevOps solutions provider, is launching upgrades to its SQL Server performance monitoring tool, strengthening its query tuning and optimization functions to facilitate enhanced ...

DBSophic, an innovative provider of performance management products for SQL Server based applications, announced that the company's Qure Analyzer solution has been ...

As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...

During the last few weeks, two events important to the SQL Server community have transpired. First, Microsoft announced SQL Server 2000 pricing. Second, the company withdrew its record-breaking TPC-C ...

Intel's Hyperthreading Technology (HT) is being blamed for server performance problems. With both SQL Server and Citrix Terminal Server installations, HT-enabled motherboards show markedly degraded ...

In this Microsoft SQL Server and JDBC tutorial, you'll learn how to connect to a Microsoft SQL Server in Java using JDBC. The steps are relatively straightforward: Each database is different, so ...