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 |
|
trouble2
Constraint Violating Yak Guru
267 Posts |
 Posted - 2006-11-22 : 04:34:04
|
| Hi hi, We had a sql express version running fine untill recently.Now it seems cause high processor use, high memory load, etc. So the websites being dependant on SQL start performing slower.Is there some way to monitor what is causing this.I can't seem to read any log files, there is no profiler in express, etc. So what options do I have? |
|
|
trouble2
Constraint Violating Yak Guru
267 Posts |
Posted - 2006-11-22 : 05:39:29
|
| Hmmm, not much response yet.I found:- you can view the logfiles, but not from Managemenet Studio. You have to go to program files/etc. /MS SQL/LOG/ and open the files with notepad. I can see the logfiles (no extension) and .trc files. The logfiles don't give a lot of detailed info. Can't use the .trc files-You can use SQL Trace. I've looked at BOL, but it's not really giving me very usefull information. So if anyone can give me some informations on this it would be great.I'm looking for stuff like:- how to start and stop trace- options I can use (I suspect some SP in a database is causing the problem, so how can I narrow down SQL trace to that database, and to specific SP's) |
 |
|
|
mightypenny_ph
Yak Posting Veteran
54 Posts |
Posted - 2006-11-23 : 01:41:28
|
| this might be out of topic, but maybe you need to REORGANIZE the table indexes on your database/s... ALTER INDEX ALL REORGANIZEfragmented data might be causing your system to slow down... :)SlayerS_`BoxeR` + [ReD]NaDa |
|
|
|
|
|
|
Log's / Profiler / Whatever