Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Aiby
Yak Posting Veteran
71 Posts |
 Posted - 2008-01-31 : 16:18:06
|
| Is there any performance issue with Stored procedures, those name starts with “sp_xxxxx” Is there any tool to analyze how it works ? and its performance |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2008-01-31 : 16:56:26
|
| The sp_ prefix is used by system wide stored procs that live in the master database. When you invoke a sp_proc, SQL Server will look in the master database first, if it can't find that proc in the master DB, then it looks inside your application database. So you pay a small amount of lookup time for every proc execution. It's not going to be a major amount, but it's good practice to not use the sp_ convention for your procs.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
|
|
|
Stored procedure name starts With sp_