so**********@yahoo.com (David McGeorge) wrote in message news:<bc**************************@posting.google. com>...
Hi
Few questions more newbie kind of things hope you can help out:
1- SQL 2000 on Windows 2000 ( and XP ), how can I utilize performance
monitoring tools on a daily basis to detect workload, usage and keep
it in a text file as a base line. What are thye most important parms
to set? Is perf monitor is part of SQL server or part of win2k or both
exacyly same?
Performance monitor is an operating system tool, and it has numerous
counters for monitoring MSSQL. Check out "Monitoring Server
Performance and Activity" in Books Online for information about it,
and other tools such as Profiler. You might also find this helpful:
http://www.sql-server-performance.com/q&a84.asp
2- Current activity in EM, has process info, locks/P ID and lock
Object. When these things can be really useful? Do I have to watch
them manually or is the a way to set it up? Is scripts do the better
job?
When one process is blocking another, you can use this information to
see what's going on, although personally I prefer sp_who2 for that
purpose.
3- how can I see how much physical mem sql server used? how is the
process and memeory utilization? Can I set alarm if it goes very up I
get inform. How
Performance Monitor can tell you the memory used by any process,
including MSSQL, and you can set alerts based on a threshold, either
from Perfmon itself or from the SQL Server Agent alerts dialogue. Note
that MSSQL will take all the memory on the server by default (unless
you configure it not to) - this is not a bad thing, unless you have
other applications running on the same server.
4- Some basic scripts but important for daily DB check?
Probably the easiest way to get going quickly is to create a
maintenance plan in Enterprise Manager. The plan can backup your
databases and/or perform integrity checks on them.
Simon