probably once every two months...
The problem with perfmon is when there's a new database on the server, will have to update the perfmon regarding the new database based on the...
I am not allowed to use perfmon because we are running a schedule tasks to run the script every 2 hours and the output will depend on their...
How about getting the value for total memory used?
Some servers I monitored has empty records on the sysperfinfo table...
Is there a script to produce transactions/sec other than using sysperfinfo?... Thanks in advance
How about the transactions/sec without using the table sysperfinfo, how can I get those value per database?... Thanks in advance.
Hi, Is there a script to capture the data size used and its log? Thanks in advance.
Using "System_user" will only get the current user login using windows authenticated.. But how can I get the other login names of windows...
Hi, How can I get the Login Name of a Windows Authenticated ID? It always generate an output of dbo...
Hi, What script can I use to get the memory and cpu usage per database? Thanks.
<br />I got it now. <img src='/community/emoticons/emotion-1.gif' alt=':)' />
hi, how can I get the file size in (MB) using xp_getfiledetails? what will be the computation? Thanks in advance.
I will. Since this is the first time I was assign as a DBA. Thanks again.
<br />There are atleast 15 servers that I have to monitor and they just only require me to use a script and a job that will trigger the script to...
sorry for the first sentence on my previous reply... They are assignning me to this job. So I am new from becoming a DBA that's why I'm asking for...
I'm afraid your are not DBA in that installation. They are assignning me to this job. So I am new from becoming a DBA that's why I'm asking for a...
Yes, it includes Performance monitor. That is why I need a script to produce an output consisting those information... please help...
Is there a way I can use a script for the information mention above?... I am not allowed to use a tools because it has to be run on a job to get...
i am new to this... how can I use this Profiler?
Separate names with a comma.
