-
SQL logs are flooded with "Error: 28005, Severity:16, State:2."
PROBLEM: The SQL broker queue is constantly climbing and I regularly see the following error in the SQL server logs. An exception occurred while enqueuring a message in the target queue. Error: 33009, State:3. The database owner SID recorded in the master database differs from the database owner SID recorded in database…
-
How can I find out what machines have a specific program installed?
PROBLEM: How can I find out what machines have a specific program installed? SOLUTION: You can create a view to accomplish this. Say we want to find all machines that have 'Firefox' installed. Here are the steps on how to do this. 1). In the top right hand corner, select the '+NEW' button to create a new view. 2). When the…
-
Kaseya Backups not automatically cleaning up
Problem Kaseya Backups not automatically cleaning up. Database backups older than three times the backup and maintenance period are discarded automatically to prevent your disk drive from filling up. Solution 1) Open the file Kserver.ini located in the folde Kaseya\kserver in the Kaseya server.Look for the line starting…
-
SaaS - Cannot view User History for all users
PROBLEM: Why can't I view the User History for all my users? Cause: You do not have the required scope assigned to you. SOLUTION: To view the 'User History' for all your users, you will need to assign the scopes that the users are using to yourself. For example, if the users have Scope X assigned to themselves, you will…
-
Identify the Top 20 queries running on the Kaseya database
PROBLEM: How do I find the top 20 queries running on my SQL server? SOLUTION: It is not uncommon for other databases to be running on the same SQL server as Kaseya. To troubleshoot the issue and determine if Kaseya is the root cause, run the following SQL query to determine what the top 20 queries running in the SQL…
-
Ksubscribers transaction log large
PROBLEM The ksubscribers transaction log file is large. SOLUTION Note: We strongly suggest that a SQL database backup be taken against the database prior to running any SQL command. You can easily shrink the transaction log file by following the steps below. Execute the SQL Query below to change the database into SIMPLE…
-
Identifying the reason for Database growth
PROBLEM: How do I determine why my database has been growing exponentially? SOLUTION: Use the (KaseyaURL)/inc/perftest.asp page as the basis for investigation. 1). Take a look at the database size and free space. You can take a quick look and see what the database size is, the size of the log file, and the amount of space…
-
How do I enable the disabled SQL broker queues
PROBLEM: On the perftest.asp page, I see that some of my SQL Broker queues are disabled. How do I enable the disabled SQL broker queues? SOLUTION: Run the following query in SQL to re-enable the SQL broker queues on your system. USE ksubscribers DECLARE @queueName VARCHAR(255) DECLARE @dcommand VARCHAR(255) DECLARE…
-
Server performance / SQL broker
Problem: I don't see any activity on the database side and none of the processes are spiking. Server is still slow and agents are dropping in and out. Cause: SQL Broker might be the reason. Resolution: Go to <Kaseya VSA URL>/inc/perftest.asp or Run the following query in SQL. select SUBSTRING(far_service,1, 50)…
-
What database mode does Kaseya use and why?
PROBLEM: What database mode does Kaseya use and why? SOLUTION: Kaseya uses simple recovery mode. It must be this way. If it is set to full recovery mode, this will require further maintenance by the user that Kaseya doesn't perform. If the database is not properly maintained, the database size will grow exponentially. When…