Hi i want information about database ( table > 30 Mo ...) and some general information about database instances :

I want create an information sheet for every server

I want create a script to gather some information about a database:

For now I have just : information about datafile (size , size used , free size , the...

Hi thk for the reply ,

I want to know the size attribute to pools , memory , cache ...

It's not possible to know if user can create for example...

Hi , it's for sqlserver

I want to see every friday the top 10 query of the week that take more time

Hi , thank you 🙂

last question : is it possible with this script to return a colum with the number of read block?

Hi , thk for reply

No index = no pk = no unique constraint

Hi ,

I tested the script but it not worked :/

I created a table with 4millions lines ( no index)

I did a select * from myTable ;

and...

Re ,

I don't see how to modify the script to obtain the history of the buffer cache hit ratio, have you an idea? :unsure:

Thank You ,

Have you a script like this , that return information about Buffer Cache hit ratio over time ?

thank for your comment.

So there is not a way to verify that it(restore) works (backup with checksum or not)

I don't know if it's the best way (but its work) :

DECLARE @backup nvarchar(90);

SELECT TOP 1 @backup = physical_device_name

FROM msdb.dbo.backupset b JOIN msdb.dbo.backupmediafamily m

ON...

thank you 🙂

(I meant no problem when using backup )

Thank you , I'll take a look 😉