SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Conflicts
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 09/07/2009 :  05:18:44  Show Profile  Reply with Quote
I don't know WHAT is happening.

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?

webfred
Flowing Fount of Yak Knowledge

Germany
8764 Posts

Posted - 09/07/2009 :  05:25:29  Show Profile  Visit webfred's Homepage  Reply with Quote
With this given information I would say you should run your queries in that times of the day they arent't using their app to manipulate records.
But we don't know what you are doing.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

mikebird
Aged Yak Warrior

United Kingdom
529 Posts

Posted - 09/07/2009 :  05:54:45  Show Profile  Reply with Quote
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
Go to Top of Page

webfred
Flowing Fount of Yak Knowledge

Germany
8764 Posts

Posted - 09/07/2009 :  06:03:10  Show Profile  Visit webfred's Homepage  Reply with Quote
I don't know why you are doing that T-SQL stuff.
Maybe you do better a copy to a different server (dev environment) (ask your admin) and do your job there?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000