I am told since I've been using this system (running queries) the users have been suffering problems (thrown out... ) using language which is not that of DBAs and nothing I can ask about.
I view sp_who_2 active to see who runs at the same time as me - I ave times of the day they aren't using their application to INSERT / UPDATE records so I can make full use of the SQL Server 2000 but I would like to know theier reasons for crashes or whatever it is.
My login is restricted - I am not a DBA at present - can't run Profiler, or kill my runaway sessions
What can I do to investigate problem causes and make things better?
What I do is T-SQL stuff, not admin stuff. Using existing views to join increasing numbers of views, pull columns and these run times are getting terrible. 30 mins was bad. Now 3 hours plus, each, and worse. Sticking to top 1, but I need more rows to aggregate on...
I blame this on a sickly slow server. 4 procs, 3.58 Gb memory