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
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.
Leave a comment
- What is the easiest way to upgrade my existing Perl 5.14 to Perl 5.16 on FreeBSD 9 using the ports system?
- Know if mysql has done its job
- Redirect https .com to https .co.uk without a valid SSL cert on .com without DNS change
- Why is it a bad idea to use customer email as from address
- 100% packets dropped on first RX queue on 3/5 raid6 iSCSI NAS devices using intel igb (resolved)