May 14, 2008 at 4:46 am
Hi,
Does anybody know or prove it, what happens with the data base when a JOB (supose that it takes more than 400miliseconds every second) is running at the same time that there are doing queries, or other things to the database??:w00t:
thanks
May 14, 2008 at 11:24 am
I don't know if you have conveyed your question correctly. A Job Agent job does not have to impact a database (other than MSDB) at all. A job could run a command line executable that does nothing related to a database.
If you have a job step that does something within a database, what it is doing is the important part about it causing resource conflicts.
May 14, 2008 at 11:54 am
It depends on what the job is doing and what the other stuff is doing.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 15, 2008 at 9:01 am
Ok, I made a mistake doing the question in that way.
I mean that if there is a stored procedure running (doesn't mind what is doing to the database) and it needs taking a lot of resources from the data base, what would happen if at the same time there is somebody doing queries or something.
the data base would stop?
it would give us an error or something else?
the data base would treat the queries as more privilegiate actions and would live the stored procedure in a second place?
I haven't done that test. It was just to know if someone has done it before, and what would happen with the data base.
May 15, 2008 at 9:03 pm
In most respects, a stored procedure is no different from a user/client executing all of the same statements in one batch.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2008 at 1:43 pm
It would queue everything up and keep on running. Users would get their queries slower. The proc in the background would finish slower too.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply