Process Info (SQL Server Enterprise - Management - Current Activity)
Jul 23, 2005
Dear All
I have problem with my database server which running SQL server 2000.
The server running very slow. The worst case, to save a record required
more than 20-30 seconds.
Since this problem, I usually monitoring Process Info from Enterprise
Manager (Management - Current Activity), and I found a misterious
process as follow :
1. User: System
AccessTo: Master
Status: Background
Common: Task Manager
Waiting: >438 Million
2. User: System
AccessTo: Master
Status: Background
Common: Task Manager
Physical IO: > 51000
3. User: Administrator (Join domain)
Database: MSDB
Status: Sleeping
Common: Awaiting Command
App: SQL Agent Alert Engine
CPU Usage: > 16 Million
Anybody know about these condition? Does it normal?
Thanks
Michael
View 3 Replies
ADVERTISEMENT
Jan 12, 2007
Hi, please i need to know where sql save (table) the info that i see in Managment/Current Activity - Process Info
thanks so much
View 4 Replies
View Related
Jun 15, 2001
Just recently I noticed something that I consider very strange on a SQL7.0 server with SP1.
In [Server -> Management -> Current Activity -> Process Info] I see a great number of rows(connections) around 70 or so that all have the same net_address value. However, the nt_loginame is different on each.
Q1: How can this be?
Q2: Isn't the net_address really the MAC of the network card?
Also, on a test SQL7.0 server with SP1 where the connections are far less (around 15 or so), I noticed the same problem. Luckily, because the connection count is low I was able to go around to each machine where the nt_loginame was used to log on and found that the net_address shown in [Current Acivity] didn't match any of these machines. Why?
-John
View 1 Replies
View Related
Jan 12, 2007
Hi, I need to know where SQL save the info that I see in the Managment/ Current Activity / Process Info
thanks so much
View 2 Replies
View Related
Jul 17, 2007
If you're passing a query from outside of SQL Server into one of your databases - is it possible to monitor the Query being processed?
I have a third party program that queries one of my databases.
Curreny activity within Enterprise manager seems to be the only thing relating to my problem.
Thanks,
i
View 1 Replies
View Related
Mar 5, 2001
Hi,
In SQL Server 7.0 Enterprise Manager | node-name | Management | Current Activity, if I try to refresh the current activity or view the current activity data, I get a hourglass for several minutes, then an error message box that says:
Error 3621: Lock request time out period exceeded. The statement has been terminated.
The statement has been terminated. [OK].
I need to see the current activity to check on blocking, etc.
Help!, please.
Boog
View 3 Replies
View Related
Mar 28, 2001
What to check on NT or Sql server it self
if
1. NT performance shows that sql serve.exe -CPU 93% memory 49000
2. Sql server current activity only sa connected to master.
Thanks
View 2 Replies
View Related
Sep 27, 2006
For SQL Server 2000 we have a user login mapped to msdb with database role membership of db_datareader and public checked. This seems to allow the developers to view the Management Activity monitor. For SQL Server 2005 the same mapping is in place but the developers cannot view the Management Activity monitor. Developers are NOT granted the sysadmin role, and should not have that role.
What permissions need to be set for SQL Server 2005 to allow users to view the Management Activity monitor? They should not be allowed to take actions on the activities.
View 13 Replies
View Related
Apr 17, 2000
I have registered a server on to my client machine successfully,but I am not finding the current activity item in the management folder on EM.How do I see the current activity on the server.Do I need to be SA for that server?My machine has NT workstation with SQL server 7.0 on it.Any one to help?
View 1 Replies
View Related
Aug 12, 1999
When viewing Current Activity, nothing shows up.
If i run sp_who, the return is normal.
If I run sp_who2, the following message is returned. (it also is returned randomly while using function in EM such as Backup/Restore.)
Msg 268, Level 16, State 1
You cannot run SELECT INTO in this database. The DBO would have to run sp_dboption to enable this option.
What is it??? It's buggin me......
Dano
p.s. I remember a similar problem in the past, it had to do with turning truncate on checkpoint in one of the system databases msdb/master/tempdb or something like that. I turned off all Trunc. and Select/Bulk options on these...
View 2 Replies
View Related
Sep 26, 2007
Hi
we have one 'application'-user in sysusers that makes the connect to SqlServer for all users, for example:
Application Login-User: Thomas
DB-Connect-User: AppUser
With this solution, in Activity-Monitor or with sp_who I don't know, what is the real name of the connected user.
Any possibility to change the login-information after the connect, so that i can see 'Thomas' in Activity-Monitor or with sp_who?
Thanks for your help.
Thomas
View 4 Replies
View Related
Nov 20, 2002
Trying to view current activity in EM however get error 1222 Lock request time out period exceeded, this also occurs when trying to view tempdb database.
Is this a EM Gui error or locking issue and hwo do you resolve?
Thanks
GaryW
View 5 Replies
View Related
Sep 24, 1999
Hi,
On sql server 6.5 running on a win/nt platform my Current Activity window comes up blank when I click on it. Everything else seems to be working fine. This is a new problem, it just stopped reporting any info when I click on it.
Any suggestions would be greatly appreciated.
Thanks,
Jerry
View 2 Replies
View Related
Nov 3, 1998
Hi there!
in the ms-enterprise manager , the current activity.. under server menu
does not display anything in one of the server in EM but in other
servers it is okay.
any inputs?
thanks.
joe
View 3 Replies
View Related
Oct 29, 2007
i'd like to block all other processes that interact with my database while my archive process is running on that database. Can this be done?
View 4 Replies
View Related
Mar 22, 2002
Hi,
I could see number process is having high value in the CPU colun of the Enterprise Manager Sp Activity.
Even I took some of the process SQL and did an explain and found to be fine.
Could you tell me why it is having high CPU value and what is its effect in system performance.
Thanks
John Jayaseelan
View 4 Replies
View Related
Sep 6, 2007
This is day 1 of me ever using RS so forgive ignorance of the topic.
Here's the basic scenario:
Input parameter from the user is an Account name.
For that account name I want to list Addresses of locations under the account, and then for each of those, I want to list received shipments from the address.
So Ideally the result is:
Account Name
Address 1
Shipment 1
Shipment 2
Shipment 3
Address 2
Shipment 1
Shipment 2
Address 3
Shipment 1
So, I am able to list the addresses just fine, but the next step is getting the stuff from the shipments table based on the currently running address? I'm probably saying that poorly. What I need to know is how do I structure the dataset/report to accomplish this. I suppose I could combine the query for the shipments with the query for the addresses, but that seems suboptimal to me.
TIA for the help.
View 1 Replies
View Related
Jan 11, 2005
I want to check who access the database in the sql server. When i go to current activity then process info. I found not all the users who access the database are displayed. Even though i refresh it. It didn't show up. But i am sure some user was accessing the database. Anybody know why, how can i avoid it. Thanks.
View 2 Replies
View Related
Jul 27, 2004
Hello, i just check the process Info in the sql server enterprise manager, I found two same user but different host (such as host1 and host2), and also i have update problem that write confilct error messager (i use access as front end and sql server as back end)
Does the two process cause problem? Actually i found the host2 computer actually is dead, why that host appear in the process Info, any body has idea? Thanks in advance.
View 5 Replies
View Related
Dec 3, 2004
I have a SQLServer that gets accessed by some medical software through Citrix. So there are about 100 users at any point in time,but I can see 650+ Processes in Current Activity->Process Info in Enterprise Manager.
The company is complaining that if they dont reboot their SQL Server everyday it gets too slow to use. Does the # of Processes have any relation to their preformance issues?
View 5 Replies
View Related
Mar 20, 2006
I had a clients dba send me a peice of sql from the Last T-SQL command window from the process info screen under current activity in the enterprise mangler. It was a select query from a large table with no where clause.I setup profiler for all of the xxxx:completed events for the T-SQL and Stored Procedure Event Classes. I played with that part of the app for a while. I could not find my sql in the trace. I finally gave in and open the Mangler and I was able to reproduce it once but I still could not find the sql profiler. It is not in syscomments and I have a developer running a FIND in the app code.EDIT: I know the sql the query processor uses is not always the sql you send it.I am kind of confused about what that window shows I rarely use it for something like that. Anyone have any light to shed?
View 5 Replies
View Related
Apr 16, 2007
I have presently installed on my local computer Enterprise Manager for access to our remote sql server. May I install sql server 2005 express and sql server management studio express on my local computer without causing conflicts with Enterprise Manager?
thanks,
damiata
View 1 Replies
View Related
Feb 13, 2008
When I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that
we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server.
Questions:
1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server?
2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC. Any expected
problems when running both 2000 and 2005 SQL Server at the same database server?
3. What is the best configuration for running SQL Server 2005 when we have old 2000 databases? Upgade or not upgrade?
TIA,
Jeffrey
View 4 Replies
View Related
Oct 21, 2005
SQL 2000 SP3================================================In reviewing this screen, I have SPIDS > 100 that have a status ofsleeping, command = AWAITING COMMAND and login/batch dates that areweeks old ... Shouldn't this list be more recent activity only ?Thanks,Craig
View 1 Replies
View Related
May 9, 2006
I was wondering if i install sql server management studio express on a pc with enterprise manager on it, if that will upgrade the enterprise manager? I was hoping to have them installed side by side so that i can manage my sql server 2000 dbs with enterprise manager and manage a sql express 05 db i have on another pc with the managment studio.
Thanks!
View 1 Replies
View Related
May 9, 2006
I was wondering if i install sql server management studio express (05) on a pc with enterprise manager(00) on it, if that will upgrade the enterprise manager? I was hoping to have them installed side by side so that i can manage my sql server 2000 dbs on a server with enterprise manager and manage a sql express 05 db i have on another pc with the managment studio.Thanks!
View 4 Replies
View Related
Nov 13, 2007
Good morning,
I have a project that consists of modifying a report in Crystal. The problem is that I know very little about SQL and I need to add some data items to Crystal using SQL. The guide that I was given refers to Enterprise Manager and SQL Query Analyzer but they have since upgraded to SQL Server Management Studio. Can anyone translate the following statement into SQL Server Management Studio so that I can complete this process?
Best regards,
We will now edit the View on the MS SQL server. Open Enterprise
Manager and find the cst_adEnroll_MyInitials _vw in the Views
section of the database. Right-click, select Copy, then go to the
menu bar and Select Tools and SQL Query Analyzer. Once Query
Analyzer opens: Change CREATE to ALTER before the view name.
View 1 Replies
View Related
Jan 21, 2015
I have a table with score info for each group, and the table also contains historical data, I need to get the ranking for the current week and previous week, here is what I did and the result is apparently wrong:
select CurRank = row_number() OVER (ORDER BY cr.CurScore desc) , cr.group_name,cr.CurScore
, lastWeek.PreRank, lastWeek.group_name,lastWeek.PreScore
from
(select group_name,
Avg(case when datediff(day, asAtDate, getdate()) <= 7 then sumscore else 0 end) as CurScore
[Code] ....
The query consists two parts: from current week and previous week respectively. Each part returns correct result, the final merged result is wrong.
View 3 Replies
View Related
Aug 25, 2005
When I was trying to get my maintenance plans to work there were many processes I had to kill. These processes were killed over a week ago but they still list in the Current Activity | Process Info list. Under Command it says "Killed/Rollback". If I go into QA and run kill 65 with statusonly it says the process is complete. How do I get these processes off the list?
View 4 Replies
View Related
Jul 23, 2005
Hi,I'm running SQL Server Version 8.00.194 on Windows 2000.I am am running this query:select TOP 2000TheoVolImpliedfrom OptionTradeswhere ReutersSymbol = 'IBM.N'and TheoVolImplied > 0.0TheoVolImplied is of type float, precision 15, length 8.When I run this query I get this error:Server: Msg 3628, Level 16, State 1, Line 1A floating point exception occurred in the user process. Currenttransaction is canceled.If I run this query:select TOP 2000TheoVolImpliedfrom OptionTradeswhere TheoVolImplied > 0.0It works fine with no problems.If I run this query:select TOP 2000TheoVolImpliedfrom OptionTradeswhere ReutersSymbol = 'IBM.N'It works fine with no problems.Anyone have any ideas about what might be wrong?
View 2 Replies
View Related
Mar 20, 2006
Hi,
I am using Sql server 2005 express edition, and I want to import a table to text file using express manager.
How to use the Management studio to Import the table into text file as using in enterprise manager in Sql server 2000?
As many of you may faced this problem, if you can please help me.
regards,
km.
View 2 Replies
View Related
Apr 16, 2007
Hi,
I'm using Vista Enterprise edition and my SQL Management Studio (2005) works very well but the object explorer shows still + and - signs in the treeview. When I open SQL Server Enterprise Manager (2000) then I see the little triangles I'm used to view in the Windows Explorer from Vista itself.
Is there any way to enable the Vista look and feel in the Object explorer of SQL Management Studio as well? This is merely a GUI question but it would be nice to have it .
Grz, Kris.
View 2 Replies
View Related
Feb 25, 2006
Hi,
We patched our servers last week and now, when connecting to our server remotely via Enterprise Manager (with DBO permissions), the management folder shows as empty. My guess is its permission related but, I'm not sure where to begin to correct the issue since we aren’t sure how it happened. Any help will be greatly appreciated.
~des
View 1 Replies
View Related
