SQL Server 7.0 How To Disable Msdb.dbo.sp_sqlagent_get_perf_counters
Jan 25, 2004
Hi,
we are using MS SQL 7.0 and whenever the sp EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters runs it causes huge io reads and at the same time CPU Util of Database server goes to 100% though the CPU util of this proc is 0 or near zero..
I am not sure though that this is the problem ...but to check whether this is the problem i need to disable this...
This runs every 20 seconds and i know we can disable this is sQL 2000
by changing registry settings ...
Is there a similar way for SQL 7.0 to disable this sp
View 2 Replies
ADVERTISEMENT
Jun 20, 2001
Hellow!
One of my production server is executing sp_sqlagent_get_perf_counters procedrue every 60 seconds.
Why?
How to Stop it?
TIA,
Paul
View 4 Replies
View Related
Jan 24, 2007
I have problem with my production server, it is 4 CPUs and they utilized 100%. And i found this stored procedure EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters taking highest CPU time. And i already turned off all the alerts. And i even killed this stored procedure, but still it is executed by some process, i don't know how it is executing.
Kiran
View 5 Replies
View Related
Nov 21, 2005
Whenever I start my SQL Express 2005 database, I get the following in the logs :
View 10 Replies
View Related
Feb 23, 2008
Hi,
Get an error in the log, "The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs." and for the moment I just wan't to disable all the server loggings.
Indeed errors should be investigated, but not for the moment...
Thanks!
Rickard
View 3 Replies
View Related
Aug 9, 2007
Hello all!
First of all our servers:
SQL_PROD: production server with SQL Server 2005
SQL_TEST: test server with SQL Server 2005
What we are trying to do:
We are testing our backup and recovery procedures.
To do so we are using the backups from SQL_PROD and restoring them on SQL_TEST.
We are restoring: all user databases, master database, msdb database and model database.
The issue we are experiencing:
I think we've hit a kink in our recovery procedures concerning msdb database in the context of a recovery on another machine (SQL_TEST in this case).
We include msdb in our nightly backups so that, in the event of server loss, our maintenance plans and jobs get restored.
On SQL_TEST (after a recovery), the maintenance plans and jobs do get restored but the problem is that they reference the SQL_PROD server (server's name, disks, etc...).
Deleting the jobs and maintenance plans from SQL_TEST we got no errors and the jobs and plans disappeared from beneath the Maintenance Plans and Jobs nodes. Doing a refresh on the nodes, the €śdeleted€? plans and jobs reappear beneath their respective nodes! Upon the second deletion (and any consecutive delete) we get the error:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
...
The SELECT permission was denied on the object 'sysmaintplan_plans', database 'msdb', schema 'dbo'. (Microsoft SQL Server, Error: 229)
Clicking on "Show technical details" reveals this:
...
Server Name: SQL_PROD
Error Number: 229
Severity: 14
State: 5
Line Number: 1
...
Note that SQL_PROD is being referenced in the error message!
This morning I took a look at SQL_PROD€™s Maintenance Plans and Jobs (the source of the msdb backup) and surprise surprise: THEY WERE ALL GONE!!! This is a MAJOR BUG!!! Deleting a job or a plan on one server should not have the effect of deleting it from a different server (regardless of the origins of the msdb database). Is this a known bug? Or is it considered €śnormal€? behavior?
My questions are:
How do we delete the maintenance plans and jobs from SQL_TEST without deleting them from SQL_PROD?
What is the proper/recommended method to backup and restore maintenance plans and jobs (in fact msdb)? Is it by scripting things and recreating them on the recovery server in an empty msdb or is there a way to restore msdb properly from the crashed server?
Thanks for your help.
Regards,
Mark Tabash
View 11 Replies
View Related
Apr 18, 2008
Hi,
is it possible to enable a user to perform changes on some SQL Server tables,
but to disable the changes on the same tables via MS Access for this user?
E.g. I can change a table on SQL Server, and me and some other users access the table via MS Access. I disabled the changes on the table by other users in general, only I can perform changes.
But I also want to disable the changes for myself if I view the table in MS Access.
Thanks
Katarina
View 2 Replies
View Related
May 8, 2008
Hi ,
Recently i enabled audit by selecting properties of the server and enabling audit-all.
Now i disabled audit by select audit level=NONE.Still i get trace files.
Can anyone help me,how to stop this?
I also rebooted the server??
View 2 Replies
View Related
May 15, 2008
Hi,
I disabled audit by right-clicking the server->security->and disabled audit->none..But also we seeing audit files.
Can anyone help me??
View 8 Replies
View Related
Nov 5, 2015
How can I disable windows authentication mode in SQL Server using sql query or a windows command.
I know how to do it using management studio. i.e., security --> logins --> Builtin/Administrators --> status --> login --> disabled.
But I need to do this using the command.
View 6 Replies
View Related
Nov 10, 2005
I have a server attached to a SAN, all user db's are on the SAN, master, tempdb, and msdb are on the local machine. We will be replacing the machine (not the SAN) to a newer sql server. Our plan was to create the new server with same name, deattach current user db's,backup master and msdb, then connect new server with same name an IP to SAN. I then wanted to restore the master and msdb db's to the new machine, and attach the user db's. We are running log shipping to a stand-by server in this configuration. I was thinking I could let last tran log backup and copy occur, and then let the last restore happen on the standby. I would then shut down the agent. Should I not be able to restore the MSDB and master to the new server (as long as all file folder locations are the same) and be ready to go? Or are there issues when restoring the Master and MSDB to a new server from a different server.
View 5 Replies
View Related
Jul 20, 2005
HiI have a problem creating a backup in SQL Server 6.5. Although, thebackup produced does restore ok, I want to stop this error messageappearing everytime I make a backup. The error message is:"[SQL Server ]Can't allocate space for object 'sysbackupdetail' indatabase 'msdb' because the 'default' segment is full. If you ran outof space in Syslogs, dump the transaction log. Otherwise, use ALTERDATABASE or sp_extendsegment to increase the size of the segment."this articles appears to describe the problem and the solution:http://support.microsoft.com/defaul...kb;EN-US;152354It recommends creating a stored procedure to delete old entries. Thestored procedure cannot be created due tro a memory problem. What Iwas wondering, although the article doesn't mention it, can a newdevice be created and added to the msdb database. This should fix theproblem or is there problems doing this ?Thanks in advance
View 1 Replies
View Related
Jun 8, 2007
When I open server managment studio and try to connect to Intergration
Services, I can connect to that but when I try to open the Stored
Packages --> MSDB folder, I'm getting the following error message:
'Failed to retrieve data for this request'
Client unable to establish connection
Encryption not supported on SQL Server.
I'm logged in directly to the server, how can I be able to connect so I can
import DTS packages and view them in the MSDB folder?
View 1 Replies
View Related
Aug 7, 2006
I depolyed several package in a server A msdb in some logical folders
E.g. msdbTask1package1
msdbTask2package2
msdbTask3package3
I would like to migrate the package to other server B and keep the logical folders tree.
I know I can reploy the packages in B and move them to the logical folders tree one by one, it is too slow.
Is there any fast method to migrate the package and keeping the tree?
Thanks.
View 1 Replies
View Related
May 6, 2014
I have a trigger that executes AFTER INSERT, UPDATE, DELETE. Is there a way to disable and then reenable only the "AFTER DELETE", letting AFTER INSERT, UPDATE act normally?
View 6 Replies
View Related
Oct 25, 2015
the disable trigger will be enable again.Because I already disable the trigger on last month, but when I check through the database, it enable again.I understand that, when we restore the database, all the trigger will be enable.How about SQL Cluster? will it enable the trigger??
View 3 Replies
View Related
Jul 17, 2006
Hello,
I have a big problem with SQL Server 2000 and Visual Basic .Net. I wont disable named Pipes from code write in Visual Basic (.Net). How make this ?
This problem is very important for me.
Help me! Please!!!
View 1 Replies
View Related
Jan 12, 2008
Hi all,
I am sorry if i am posting this error in an inappropriate froum.
Well in my asp.net intranet web application i want to enter a number to the database(sql sever 2005) that has a column(schoolkm) whose type is decimal(9, 2). Now if i want to enter the value 1.5 in the text box and enter that value to the database through interface then that value automatically rounds to 2. But when i get into the table and enter that value by hand then that value enters perfectly i.e. without rounding of. I want to know the reason and how can i cure this problem.
Regards & thanks in advance
View 5 Replies
View Related
Jun 19, 2014
It's often said or done that when inserting or updating into a 'large' table that disabling the non-clustered indexes can is needed for performance.
Now I know the obvious way to find out if this is best or not is by testing the different options. I was wondering if there was a rule of thumb to this?
Say you have a table with half a billion rows and 4 non-clustered indexes and are only updating half a million rows then sometimes disabling every night and re-enabling can take way more time than the actual update. Haven't found an articles advising to disable them when a table is over X rows and you are updating Y% of them...
View 5 Replies
View Related
Jun 20, 2006
Is there a way to do this at the server level?
Thanks
View 4 Replies
View Related
Dec 20, 2006
Hi,
I have windows 2003 (SP1) server with sql server 2000 (SP3) .
In the server network utility, I have enables only TCP/IP protocol and disabled the Named pipe protocol.
Now if I try to connect to the sql server from a remote machine, I get the message saying "unable to connect either server does not exist or ......".
I have configured the firewall to allow communication on TCP port 1433. It didn't help. I tried to disable the firewall completely, still it didn't work.
It works only if I enable Named pipe in the server's server network utility.
- Abhijit
View 1 Replies
View Related
Aug 23, 2006
We have tested mirroring with success.
Now we want to completly disable mirroring, and have done this on all mirrored database.
It seems though that the server stille maintains the mirror endpoints, hence you can do a "telnet localhost 5022".
How can we disable the mirroring endpoints ?
Martin Tan
SQL DBA
View 1 Replies
View Related
Jun 13, 2001
Hi,
I am having problems with my SQL server Agent.
1) When I try to create a New Job/Alert/Operator, I get an error message:
Error 207: Invalid Column Name "category_id"
Invalid Column Name "netsend_address"
Invalid Column Name "last_netsend_date"
Invalid Column Name "last_netsend_time"
.....All these are referring to columns in System Tables of the system Database MSDB.
2)In another SQL Server...say "A", in it's SQL Server Agent, using the Multi-Server Administration, I set up the SQL Server Agent of "A" as the Master (MSX) server, and set up a Target(TSX) server pointing to the Server "B" that has problems in SQL Agent....referred in 1) above. When I try to "Detach the MSX Server" from server B, i get a message Error 207: Invalid Column Name "netsend_address", and cannot detach..........This is again referrring to a System Table.
It appears that the problem is with the MSDB database being corrupt. Is there a way I can Repair a Corrupt MSDB without Re-installing SQL Server 2000 and without a Backup.
Any help greatly appreciate.
Thanks
Russell
View 6 Replies
View Related
Mar 25, 2015
I was recently tasked with creating an automated process to refresh SSIS packages from MSDB on one server to another and I decided to go the route of using Powershell, however this wasn't as straight forward as I originally imagined so I thought I would share my solution in case others encounter the same request. The below PowerShell code will create all Integration Services folders from the source MSDB (that contain SSIS packages) on the target instance of MSDB then copy all packages to the proper folder locations. The /QUIET option is used to automatically overwrite packages that already exist on the target so make sure you want to overwrite the current versions of your packages before executing.
[Reflection.Assembly]::LoadWithPartialName("Microsoft.SQLServer.ManagedDTS") | out-NULL
$app = New-Object Microsoft.SqlServer.Dts.Runtime.APPLICATION
$SourceServer = "<source server name>"
$TargetServer = "<target server name>"
$Packages = Invoke-Sqlcmd -MaxCharLength 10000000 -ServerInstance $SourceServer -Query "
[Code] .....
View 0 Replies
View Related
Dec 3, 2007
I have a sql2000 server that has failed
i moved the databases to another server
I am trying to restore msdb to another server is this possible in order to get the dts packets and the jobs
View 5 Replies
View Related
Mar 16, 2015
Any command through that can I delete/disable the DWORD value "Pendingfilerename operations" so that while I start the SQL Install work, it does not fail due to this and can write this as one of the precheck options.
View 0 Replies
View Related
Aug 29, 2007
HI all,
I would like to ONLY allow using SQL Server authentication and restrict Windows Authentication. At the moment, i set the security to "SQL server and windows authentication". Now, even though i set the password for "sa", i can ignore the SQL Server authentication and just use Windows authentication to manipulate database objects???
can anybody give some suggestions to restrict windows authentication and allow sql server authentication?.
Thanks in Advance
Best Regards
Ihsan
View 1 Replies
View Related
Jan 5, 2007
I created several packages (MyProjectPart1 - MyProjectPart9) which I execute on the server directly(right-click package in integration services and execute). These packages alI deployed the server with logging and configuration files. Before deploying I edited the configuration file (changed all dependent file names and sql server name from default on my workstation to those unique to the server I'm deploying it to) and then ran the manifest file which pushed it onto the server. I then ran the packages from the server an it ran beautifully. I then tried to build a package which executes all the packages in the correct order (by adding 9 execute package tasks). The dependen files are on the E: emp folder on the server.
I have included the error messg...but it looks like it's looking for dependent drives on the C drive on my workstation. I don't get this? How do I supply configuration files? Why is it executing differently when I call it from package execute task and when I execute it on SQL Server
SSIS package "RUN_MY_PACKAGES_ONSERVER.dtsx" starting.
Information: 0x40016041 at ProjectInfo_NET_SSISA: The package is attempting to configure from the XML file "C:TempMyProjectPart1-03-2007-MyProjectPart1.dtsConfig ".
Error: 0xC001404B at MyProjectPart1, Log provider "SSIS log provider for Text files": The SSIS logging provider has failed to open the log. Error code: 0x80070015.
The device is not ready.
Error: 0xC001404B at MyProjectPart1, Log provider "SSIS log provider for Text files": The SSIS logging provider has failed to open the log. Error code: 0x80070015.
The device is not ready.
Error: 0xC001404B at MyProjectPart1, Log provider "SSIS log provider for Text files": The SSIS logging provider has failed to open the log. Error code: 0x80070015.
The device is not ready.
Error: 0xC002F304 at Drop Unecessary Tables, Execute SQL Task: An error occurred with the following error message: "The device is not ready.
".
Task failed: Drop Unecessary Tables
Warning: 0x80019002 at MyProjectPart1: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: Execute Package Task MyProjectPart1
Warning: 0x80019002 at RUN_MY_PACKAGES_ONSERVER: The Execution method succeeded, but the number of errors raised (4) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "RUN_MY_PACKAGES_ONSERVER.dtsx" finished: Failure.
View 3 Replies
View Related
Jul 23, 2014
What is the best way to restore a database from a folder of backups (including full, diff and log backups) without using the backup history in msdb?
I have a restore process that restores all backups on a regular schedule in order to fully verify their integrity. To do this, I use the backup history in msdb on each server that I'm monitoring. I had a thought the other day that I would be in trouble if I lost msdb. Then my backup history would only be as good as the last backup of msdb.
What I'd like to do is read a folder of backup files and generate a restore script up to a specified time. Would I use RESTORE HEADERONLY to do this? If so, would I use PowerShell to traverse each file in the folder?
View 6 Replies
View Related
Oct 2, 2014
I have the following setup:
- An MSSQL 2014 Standard server that houses multiple small databases (in excess of a hundred).
- These databases are frequently dropped and restored by an application that uses this SQL Server.
- There is a business need for this setup at this time, so I can't get away from it. Therefore answers like "don't have so many small databases that are frequently dropped and restored" would be somewhat unuseful
This is the problem I have:
- When I connect SSMS 2014 to the server and expand the "Databases" node, it takes forever to display. In comparison, SSMS 2008 connected to SQL 2008R2 server with the same number of databases displays the Databases tree very quickly.
I ran a trace to see what exactly SSMS 2014 is doing. When the "Databases" node is expanded, it runs a query that checks each database for Memory-Optimized Tables (new and wonderful feature of SQL 2014 for sure, but I'm not using it, at least yet). Naturally, when you have to loop through over a hundred DBs, it takes time. Worse yet, if one of these DBs is in process of being restored, the query sits and waits to time out before proceeding to the next DB. Sometimes this causes outright timeouts. Here is the query:
use [MyDatabase]
SELECT
ISNULL((select top 1 1 from sys.filegroups FG where FG.[type] = 'FX'), 0) AS [HasMemoryOptimizedObjects]
To be sure, this is NOT a SQL Server performance issue. This server processes a rather heavy workload and has been doing so for over a month, and the workload completes within expected time limits or better. Even so I've done some basic performance measuring, and the server itself is quite all right.
Moreover, if I connect SSMS 2008 to it, I get an error message (Index out of bounds or somesuch), but SSMS 2008 does connect, and displays the Databases tree much faster than SSMS 2014.
I'd like to turn off the option to check for Memory Optimized Objects altogether, as I'm not using the feature.
View 3 Replies
View Related
Mar 25, 2014
Am customizing SQL server MGMT tools 2012 for Mass deployment.Client had asked to remove Customer Feedback option from help menu.how to disable that.
View 6 Replies
View Related
Jan 15, 2002
Hello
I have a very large base msdb, I do not arrive has to purify it with sp_delete_backuphistory, it is much too long, have another solution? thank you
View 2 Replies
View Related
