Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-10 : 09:29:45
|
| Tony writes "Having installed our application on several SQL Server based customers all went well, until load increased.Now we have customers reporting data servers at 100% for no obvious reasons.Servers are providing data for our ASP app and Crystal Reports. Is there an easy way to find out what the server is doing?On our previous DB Engine (Pervasive/Btrieve) there is a monitor that can tell what each client is doing by table and records read.ThanksTony" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-10-10 : 10:59:30
|
| Take a look at running a trace using SQL Profiler.Jay White{0} |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-10-10 : 12:58:36
|
| Tony,How did you port the data access code which originally accessed a Btrieve system to access a SQL Server installation? I ask because Btrieve is not a database in the relational sense; rather it is a record management system in the same vein as Lotus Notes. Many conversions from these systems result (initially) in reduced performance because the developers involved aren't accustomed to relational thinking.Jonathan{0} |
|
|
|
|
|
|
SQL Server at 100%