Percentage I/O by each database can be found using DMVs.

WITH Agg_IO_Stats

AS

(

SELECT

DB_NAME(database_id) AS database_name,

CAST(SUM(num_of_bytes_read + num_of_bytes_written) / 1048576.

AS DECIMAL(12, 2)) AS io_in_mb

FROM sys.dm_io_virtual_file_stats(NULL, NULL) AS DM_IO_Stats

GROUP BY database_id

)

SELECT

ROW_NUMBER() OVER(ORDER BY io_in_mb...

I think this is possible only through stored procedures. Function can't provide such functionality.

Did you check if there was any blocking on the table during INSERTs?

Thanks.

Thanks for the replies.

security_admin server role is used to create logins and give access at the server but not at the database level. It didn't work.

sp_change_users_login will not work because...

Thanks for the reply. Problem here is how can this be accomplished by developers itself without contacting DBA and we don't want to give sysadmin permissions to developers.

Deveopers has db_owner...