SQL Server Performance Forum – Threads Archive

stored procedure naming convention

Hi,
my stored procedures names begin ‘sp_’.
does it have a bad effect on the performence.
Someone told me this reduces the performence since this convention is used by SQL Server system. Thanks,

---

No at all.
As far I know there is no documentation about it.
Luis Martin
Moderator
SQL-Server-Performance.com The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.

---

SQL Server looks for stored procedure beginning with sp_ first under database master (unless you specified database name) then in current database. So I would not use sp_ in stored procedures in production databases. you could use usp_ or other.
I do have a few stored procedure in master database that does general things, like search for a string in a stored procedure, in this case I use sp__ (2 underscored) so I can call these procedure from every database, and I can still tell my procedure from the system procedure.

---

Here’s a link to a MSDN article supporting bambola’s comments: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_07_7yw5.asp If the link doesn’t make it, the article is on msdn under: MSDN Home > MSDN Library > Enterprise Development > Windows Server System > Microsoft SQL Server > Microsoft SQL Server 2000 > Stored Procedures

---

These article might also help explain http://www.sqlservercentral.com/columnists/jtravis/sp_performance.asp
http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp
Frank
http://www.insidesql.de
http://www.familienzirkus.de

---

]]>