Number of Stored Procedures
-
Hey SQLers,
For those of you with an enterprise application out there using MS SQL, how many stored procedures do you use with your application? I'm just looking to see if I'm anywhere near the right ballpark?
Thanks,
Ryan
Rational Anarchy -
There's no fixed number. I can imagine a large datastore having only a few dozen sps running an 8 way server to the ground while another app with 1000+ forms and 5K sps will only take a daul proc server because the procs are all extremely quick to execute and that there are only a few dozen users on the system. It all depends on the needs of the application.
-
Right, so those are the types of examples I'm looking for. I've jumped into the middle of this company and I'm trying to improve the performance of the software. I was just wondering if Stored Procedures were a good place to turn to try improving performance or if I should concentrate my little free time in other directions.
Thanks!
Rational Anarchy -
Here's how I look at Stored Procedures...
Let's say you have an application (for example: Crystal Reports), that has 5 users. Each user queries the same data.
You have two choices....
1. create a Crystal Report script that will run on each user's system
2. create a stored procedure that Crystal Reports executes.
Guess which one is easier to maintain? With the stored procedure, you don't have to update each user's Crystal Report script. And you know what they are running because they can't make changes to it.
-SQLBill
-
Check this out for articles on performance tuning. This will get you going
.http://www.sqlservercentral.com/articles/articleList.asp?categoryid=37
-
Brad McGehee has a site with good advice on performance tuning:
http://www.sql-server-performance.com/
Greg
Greg
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply