Thanks for your suggestion! Will try this out on first occacion we can take db offline. I hope this will solve the issue, I'll keep you posted. thx

thx for the link & tip Gazareth, I will have look. Maybe output to file solves it...

Hi,

had the same issue for our DEV team required extra Agent job access. This is how i got around it.

1 ActDir group. Hold all user accounts that need such access

2...

What I do is create a 2 or 5Gb dummy file on each SQL disk (ldf,mdf,tmpdb). Whenever there is an urgent disk storage problem I can delete the dummy file...

Good & well written article Theo. Useful to know. Thanks

Rgds,

T.

.be

We also use a logon trigger to catch all logins to table and cleanup after xx days.

Orphaned sql logins just get deleted. As for network accounts, I use a powershell...

thanks already for your input Alen, Steve.

As you mention Steve, it could be an option to move a high-resource to a different server. Now I have no idea which...

hey, thanks for the reply. This looks very interesting indeed, will have a look at it now.

Such things should be make forum-sticky 😉

Thx!

Jason,

Is it also possible to show the last_duration? Avg & Max is nice as it is, but bit misleading for me now.

I hope not too much work 😉

Thx 4...

Andrew thanks for pointing that out to me. Was using wrong syntax.

Thanks for the help man!

Brgds

T

Heeeeey, this is great! Thanks for your help & effort Jason!

thxalot

Grtz

T.

Create another group with same context, say SQL remote Admin. Add this group to each servers manually as a remote desktop user, and admintrators. Add DBA group as a member...

i understand. The uptime now is about 7months. I presume this is long enough + fact the index usage = zero.

thank you for your input Jeff! Will try this.

rgds,

T.

owkee.

I need you clothes and motorcycle... 😀