Matt Klein, performance is a tricky area to comment on. The server's performance depends on various factors and we can't give a bulleted list to check that would improve things. Having said that, there are few parameters that we can readily look upon to resolve some of the mentioned issues. You had mentioned about the socket exceptions. This generally happens when there's a disconnect between the application and database. In some of the customer cases, we have seen that the deployment of more than one network card had resulted in such exceptions and we have to correct it. I would suggest you to open up a case with support and after collecting relevant details about the application and deployment parameters, we should be able to help you to use the application without any issues.
As far as the Dashboard, ensure that the queries that you had configured do not return more records (while having a graphical view), else will give the said message. Refer to https://communities.bmc.com/docs/DOC-118205
I agree with Sridhar here. Opening a case with support would be the best option to try to look at logs and configuration to see why this is happening. For the dashboard, similar advice Sridhar gave also. If the chart is set to a view that returns more records than it can render in the given space to provide a useful image, the chart will show that message.
1 of 1 people found this helpful
Thank you for the detailed response!
With regards to the errors, we will get a ticket open with support to investigate.
With regards to volume (tickets & assets), in your experience is there a quantity where degradation begins to occur? Is there a recommended total ticket count that, when reached, a reset of the database is recommended? Is there a max asset quantity the Inventory module is designed/recommended to handle?
The most obvious question is “Are you using the SQL Express shipped with Track-It!? Hopefully not as it is really there for evaluation and very small environments.
Second question; Are TI, TICM and SQL all on the same box as was the default during
Thanks for the reply Joe!
With regards to the first question and SQL Express, I am unsure at this time how it was set-up, but I will find out and get back to you.
In reference to your second question about the various services running on the same box, I think your question ended up being cut short. Did you mean to say default during setup?
I apologize, but surgery and meds took me offline for a day or three.
Yes, to both. The default installation is configured to install SQL Express unless you specify otherwise. The Express edition has limitations in how much RAM it can use and other performance effecting factors. In the default installation, both DBs are created on the same Express instance. TI has a DB and BCM has a DB that synchronizes to TI. Not an issue in smaller implementations.
So, with the default installation, you have the TI application, the TI DB, the TICM application and the TICM DB all running on the same box, fighting for the resources. Increasing memory will have little effect on the SQL performance.
In an environment that needs to “Scale”, you may need to consider separating the DBs to a real SQL server, and in very large implementations where TICM will be delivering software installs and updates, patches, managing the configuration settings and auditing operational and regulatory policy (whew), you may want to separate that as well.
TICM can scale to (documented) over 100K nodes. But there are configuration options that may be needed to fix your scaling issues.
Contact your account rep if you’d like to set up a more in-depth discussion.
Thank you for the in-depth response Joe!