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.
If you have a SQL job that rebuilds indexes automatically, those jobs will often show their sql_text as
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.