I have Windows service that it is Hitting my database MS SQL SERVER
2005 in every 10 sec.
and running sp's (each of size max is 2kb).

that's why I have a doubt

Is this any Performance Issue.

Will It become any slow of my database performance.

please reply me ...................Its Urgent

ravi kiran (ravikiran.ie027 (AT) gmail (DOT) com) writes:
You should not ask us if you have a performance issue - ask your users,
they are the one to know.

Anyway, the size of the procedure is irrelevant. A small procedure
without no good index to support it can be a big performance issue.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx