3
The calcuation of the "long running query with low cpu" metric in sp_BlitzCache at the time of writing is
long_running_low_cpu = CASE WHEN AverageDuration > AverageCPU * 4 AND AverageCPU < 500. THEN 1 END
With AverageCPU = (total_worker_time / 1000.0) / execution_count
And AverageDuration = (total_elapsed_time / 1000.0) / execution_count
Both ...
2
I achieved something close to what is being asked by using prebuild events. In my case I wanted different users and logins to be included in a deployment according to which configuration was being built.
To do this I created a .sql file for each build config, for each user. I flagged these as Build Action 'None': (I put these in a subfolder of the project)
...
1
You're right. While the procedure executes correctly from SQL or PL/SQL code, somehow SQLDeveloper raises an exception when you invoke the procedure (via the green arrow) and pass anything as input that contains a "@" sign. It's either a peculiar behavior of SQL Developer or a bug.
But executing it directly works fine, also from SQL Developer:
1
You In para meter is not country_idcountry it is countryID
see
PROCEDURE `setState`(IN `statename` VARCHAR(100), IN `countryID` INT(11))
So you mus use
SET @countryID := `countryID`;
To grab the country_idcountry.
Be aware when country_idcountry is a foreign key you must have the county id already in your database.
Only top voted, non community-wiki answers of a minimum length are eligible
