Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL server 2005 :: Windows service is hitting my database every 10 sec Is any Performance Issue.

1 view
Skip to first unread message

ravi kiran

unread,
Jun 2, 2010, 9:31:26 AM6/2/10
to
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

Erland Sommarskog

unread,
Jun 2, 2010, 5:43:08 PM6/2/10
to
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, esq...@sommarskog.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/prodinfo/previousversions/books.mspx

0 new messages