gharrison · Senior Database Administrator · ✭✭✭✭✭

Comments

  • Unfortunately I don't have access to the vendor code calling the stored procedure, but the procedure itself is very long and complex, using multiple temporary tables (although not a single index is created on any of them ... argh). Whether the vendor is explicitly calling the procedure with "WITH RECOMPILE ", or SQL is…
    in Query Execution Count in DPA Comment by gharrison May 2016
  • Mandevil, Thanks again! You're advice works great, seemingly for every query but the one I'm actually interested in. Not sure why, but this one doesn't display the execution statistics, even though it's the highest consumer of resources, and responsible for the most amount of wait time. I don't get it, but I'll just work…
    in Query Execution Count in DPA Comment by gharrison May 2016
  • Thank you so much! I have a suspicion how this happened … another application needed SYSADMIN to do it’s install onto this shared database server. I bet it applied this change to all existing database. Argh!!! Thanks again, Glen
    in DPA granted CONNECT to GUEST Comment by gharrison February 2019
  • Thanks! I was trying to look at an entire day, not an hour interval. The fields are their when I look at the hour interval, although they are blank. I'll look into possible statistics updating to see if I can get them populated. Thanks again for pointing me to the hour interval. I wonder why these are not displayed when…
    in Query Execution Count in DPA Comment by gharrison May 2016
  • Thanks for looking into this! Be careful though, it’s not obvious that CONNECT has been granted. Here’s a query to check: SELECT DB_NAME() AS DatabaseName, 'guest' AS Database_User, , FROM sys.database_permissions WHERE = DATABASE_PRINCIPAL_ID('guest') AND LIKE 'GRANT%' AND = 'CONNECT' AND DB_NAME() NOT IN…
    in DPA granted CONNECT to GUEST Comment by gharrison February 2019
  • After working with the query provided to report on this data, I think the following may work a bit better. I had an issue with a predicate throwing an error when converting the string to a float, because there was non-numeric data in the table (even though it wasn't being returned in the query). In any event, if someone…
    in Custom Alert - SQL Server Database Size Collector Comment by gharrison June 2014
  • Here's a slightly modified version that I came up with, when trying to get AppInsight to connect to my SQL DBs, in case it's helpful to anyone: USE master CREATE LOGIN [Domain\AppInsightUser] FROM WINDOWS WITH DEFAULT_DATABASE=[master] USE master CREATE USER [Domain\AppInsightUser] FROM LOGIN [Domain\AppInsightUser] WITH…
    in AppInsight for SQL Permissions Comment by gharrison May 2019
Avatar