Re: Max Number of Stored Procs in 1 Database (sql server 200)
From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 11/29/04
- Next message: we7313: "Can you select from a Derived table calling a stored proc?"
- Previous message: we7313: "Max Number of Stored Procs in 1 Database (sql server 200)"
- In reply to: we7313: "Max Number of Stored Procs in 1 Database (sql server 200)"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 29 Nov 2004 08:43:33 +0100
On Sun, 28 Nov 2004 16:19:03 -0800, we7313 wrote:
>Whats the maimum number of stored procedures you can have in one database?
>Would I notice any performance degredation if I had over 2,000?
Hi we7313,
There is no seperate maximum for number of stored procedures, but there is
a maximum number of object. From Books Online:
"Database objects include all tables, views, stored procedures, extended
stored procedures, triggers, rules, defaults, and constraints. The sum of
the number of all these objects in a database cannot exceed 2,147,483,647"
I never noticed any performance degradation on increasing the number of
stored procedures. If you take very exact measurements, you might see a
small performance degradation because of increased number of recompiles
(if a stored procedure is executed, the execution plan is generated and
stored in cache; if it is rerun later the cached plan is used, but the
cache size is limited).
Best, Hugo
-- (Remove _NO_ and _SPAM_ to get my e-mail address)
- Next message: we7313: "Can you select from a Derived table calling a stored proc?"
- Previous message: we7313: "Max Number of Stored Procs in 1 Database (sql server 200)"
- In reply to: we7313: "Max Number of Stored Procs in 1 Database (sql server 200)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
