473,327 Members | 1,920 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

admin realted questions

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?
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?
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
4- Some basic scripts but important for daily DB check?

Thanks
Jul 20 '05 #1
1 1142
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
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Candice | last post by:
Please somebody help! I've deleted my admin username and password which was initially set at test. Now I can't log into my website as the administrator. How do I put Username and Password back so...
4
by: Dave | last post by:
Hey all, Recently we had a small re-org which combined DBA teams, specifically Oracle and SqlServer. Just wondering if anyone has documentation/presentations, etc that show's how to admin a...
11
by: AnhTai | last post by:
Hi all, I've just installed MySQL 5.0 on my sun box (runing Solaris 10, install from blastwave). This is my first time with MySQL so I don't have any exp with it. I have some troubles as: -...
4
by: shashank kadge | last post by:
hi all, i am trying to get local admin users and groups on a windows server. here is the C# code that i am using...
1
by: bncs80 | last post by:
could you plz send me the windows admin questions and answer --------------------------------------------------------------------------------
0
by: sv suresh kumar | last post by:
Hi guys, can anybody send me Interview questions for the Windows Systems Administrator position? I really need them. Please can someone also email me active directory and exchange interview...
1
by: biju77 | last post by:
Hai, am Biju from Bangalore I need some system admin interview questions and answers and also some tips in Win 2003 server
3
by: =?Utf-8?B?SGVyYg==?= | last post by:
Can I use the Website Administration tool to manage users and roles for multiple ASP.NET applications using a single, common ASPNETDB? If so, what changes do I have to make to the web.config...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.