#108281 - 2003-11-19 05:16 PM
Re: Slow views running on SQL7 SP2
|
d.adams
Fresh Scripter
Registered: 2000-12-07
Posts: 41
Loc: Eagle Rock, VA, USA
|
Thanks for your replies. The server is still using the same RAID5 configuration from before, though it had to be rebuilt after the crash as well. I have looked at the query analyzer, and found bottlenecks but when I pull that little bit out and run by itself, then it runs fine. I have also looked at the Profiler some, and it really didn't tell me much. Maybe I haven't figured out the right events/properties to trace. I will have to try again later. We've been out of power (again ) here in SW VA for a couple of hours and not had much chance to work on it today. Do you have any suggestions on what events or properties I should focus on in the Profiler?
Thanks again, I will keep looking.
|
|
Top
|
|
|
|
Moderator: Arend_, Allen, Jochen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Mart
|
1 registered
(Allen)
and 373 anonymous users online.
|
|
|