performance query….. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

performance query…..

Hi All, can any one please explain me if user stored procedures and user defined funtions is having prefix sp_userprocedures; and fn_userfuntions. Like this your developers are created so many for so many user sp and user functions databases;will it be decrease the performance of the database thanks, kumar

If not for performance reasons, I would choose some other prefix just to distinguish user objects from system objects.

hi,
i am pulling standard reports from server. when ever i’ve pull it shows for some user function,user procedure.
for example fn_reports is taking cpu time 81,835,928 ms.
It is causing slowness from application point of view….
please suggest

[quote user="srimkumarp"]
i am pulling standard reports from server. when ever i’ve pull it shows for some user function,user procedure.
for example fn_reports is taking cpu time 81,835,928 ms.
It is causing slowness from application point of view….
please suggest
[/quote]
…without seeing any code and more information about tables, data volume, etc…? [:)]

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |