0

When viewing Queries by CPU usage with Performance Dasboard, I notice a great deal of queries like "Select * from dbo.sometable". What is the best way to go about tracking the source of these queries? Nowhere in my code do I run a select on a full table, but they continue to appear and SQL says they are getting executed ever few minutes. Are these actual queries or is it possible that they are being executed as part of another query, view, or stored procedure? These queries are by far the costliest queries running on my server.

Improve this question

1 Answer 1

Reset to default
0

If you have a SQL job that rebuilds indexes automatically, those jobs will often show their sql_text as SELECT * FROM [table] or INSERT [TABLE] SELECT * FROM [TABLE].

I would get on the DB and run sp_who2 or get a fancier tool that helps you hunt down more about the running processes. Google "sp_whoisactive" for example.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .