sql server Raiserror function

Question

sql server Raiserror function

Dhathri Ramamoorthi

SSC Journeyman

Points: 80
More actions
February 11, 2005 at 2:28 am

#65984

Hi,
Raiserror function is used to catch the exceptions,right.But is it a performance
degrader on the database.
can anyone clear my doubt.
Thank U
February 14, 2005 at 8:00 am

This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

AlwaysLearning SSChasing Mays Points: 627 More actions · Answer 1

My guess would be that there would only be extra overhead when the RaiseError was invoked (Maybe not even then).

You could test it by running a script without any RaiseError statements then adding the RaiseError statements and comparing the results. If the timings are the same with no errors conditions, then you should be okay.

Hope this helps

TriggerMe SSChampion Points: 11752 More actions · Answer 2

If the RAISERROR Function is a performance degrader, then so is all types error trapping in your code! As Mark Manis has stated, try it and see for yourself and then come back to us with some concrete evidence!

Kindest Regards,

noeld SSC Guru Points: 96590 More actions · Answer 3

One of the main uses of RAISERROR is to prevent client side code from creating EMPTY ADO recordsets which become really expensive objects in the middle tier of a heavily used DB. It also allows to create a message layer that can be more friendly to the front end in comparison to the default

hth

* Noel