Didn't think about PowerShell actually, anything is possible with it.

Would just need to ajust it to execute a .sql file instead of inline sql and it would do the job...

I already have and use SQL Multi Script from Red Gate. Think of how that script works, now I just need to like schedule various queries say 1 time a...

Thanks for the help, that table contained the details I needed 🙂

Thanks for the tips so far. I don't at this point have any problems on the server, all databases are running fine and performance is good. But I'm not that...

Lock Pages in memory:

This security setting determines which accounts can use a process to keep data in physical memory, which prevents the system from paging the data to virtual memory...

Well again the SQLServer:Buffer Manager -> Buffer cache hit ratio some hours later have the values 99,86 (average), 99,82 (minimum), 99,89 (maximum).

The Lock Pages In Memory (had to look it...

Are you thinking of the performance monitor SQLServer: Buffer Manager -> Buffer cache hit ratio? I've read somewhere that it should be above 90. My average is 99,86 atm.

The databases...