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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2005-12-25 : 09:01:46
|
| i have a website on a local server atthe office on 1 on the web.te 1 on the web works great and responds very fast to quries butthe local server works very slaw as like the sql server query takes lot of time - which is very strange!how can i check where is the problem?thnaks i nadvabncepelegps: i have 2003 server+2GHZ rAM,P4-2.3GHZIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-26 : 00:33:04
|
| Run the profiler and see which takes longer timeMadhivananFailing to plan is Planning to fail |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2005-12-26 : 01:59:16
|
| what profiler?Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-12-26 : 02:05:40
|
| From Bookes online :"SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of Microsoft® SQL Server™. You can capture and save data about each event to a file or SQL Server table to analyze later"Check books online for more information.RegardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
|
|
|
iis and sql server works slow