sql server performance if i have unused storedprocedures or objects.

Question

sql server performance if i have unused storedprocedures or objects.

SQL*

SSCertifiable

Points: 6638
More actions
March 2, 2010 at 1:04 am

#139141

hi,
I've one small doubt, if in my server having the lot of s.p's and functions some tables also since i have migrated from other database, and we are not using all the functionality so will it degrade performance .
thanks,
🙂

Viewing 7 posts - 1 through 6 (of 6 total)

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

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

these sp's, what is your naming convention? please tell it's not SP_yourspcustomnamehere?

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

No.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

free_mascot One Orange Chip Points: 27169 More actions · Answer 3

Except occupying a little disk space; which won't bother you 😉

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

SQL* SSCertifiable Points: 6638 More actions · Answer 4

What i'm thinking is:

when we call for a stored procedure will it search for the all the sp's suppose if i have 1000 sp's, will it not affect the performance.

Is it correct what i'm thinking?

🙂

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Why don't you test it out and let us know if there's a measurable performance impact?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

free_mascot One Orange Chip Points: 27169 More actions · Answer 6

As suggested by Gila it would be gerat if you can shar the performance data.

However SQL Server is running TB of data and billions of rows in a table without any problem. I do not see any problem if you do have 1000 or 2000 SPs extra. As frequently used SPs already will be there in memory. Likewise obsolete SPs will never come to memory.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."