Data Infrastructure Management Software Discussions

Highlighted

Re: Poor performance - DFM database server

I have upgraded to 5.1 in hopes of sybase 11 improving performance but it seems to still be the same. As I mentioned, I believe the bottleneck is the database itself. Based on the following article, my guess is that only one vcpu gets pegged waiting for a sql query to finish and as a result, any other function takes a long time to execute (when the vcpu gets pegged, I can tell from task manager that the other processes are not using much cpu resources).

http://www.symantec.com/business/support/index?page=content&id=TECH190207

Does anyone have experience with using dbisqlc to monitor what's going on with the sybase database. Not really sure what credentials to use and what connection parameters should be set to access the database. Any help would be greatly appreciated.

Regards,

Usman

Highlighted

Re: Poor performance - DFM database server

Also, I am seeing in the dfmserver.log that dfm is still trying to connect to vfiler's that were deleted a while ago. How would I go about stopping it?

Regards,

Usman

Highlighted

Re: Poor performance - DFM database server

Hi Jerome,

     In your case the problem seem to be mainly due to DP jobs per day and its history. Looks like your jobs purge is set to 21 days. I would recommend you to bring this down to 1 week.

With respect to the events purge, 5.2 will address the same. I suggest you to lower your events purge to 1month or so.

Also putting a SSD will definitely help.

Regards

adai

Highlighted

Re: Poor performance - DFM database server

Hi Usman,

     The symantec link that you point to doesnt have much relevance here. But  can you run by this VMware KB to see you are not affected by this ?

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1005362

Also the time it takes for edit of the dataset is not necessarily due to server but also few other things. How many relationship per dataset do you have ?

Regards

adai

Highlighted

Re: Poor performance - DFM database server

Hi Adai,

I was simply trying to point to the fact that we may be able to see which query is taking such a long time to execute by using the procedure in the symantec link of using the dbisqlc utility. Can you provide some guidance as how I could go about it? What credentials to use? I tried default sa with no password which didn't work.

I have verified that CPU contention is not being caused by CPU ready times %RDY or high co-stop %CSTP

Slowness is not necessarily only when editing existing datasets. It even occurs when I am adding new datasets and trying to add datastores from the data tab. Each dataset has 2-5 datastores max.

Re: Poor performance - DFM database server

In task manager, when no vcpu is at 100%, I experience normal performance on the server. Whenever any vcpu is at 100%, its associated with the dbsrv11.exe process which is what makes me believe that its the database queries causing the slowness.

Highlighted

Re: Poor performance - DFM database server

Hello Adai,

What do you means by : I suggest you to lower your events purge to 1month or so ?

There is a parameter to configure the purge of the event ?

Jerome

Highlighted

Re: Poor performance - DFM database server

I've heard rumors that number of running DP jobs may be related to this issue. But how to collect number running DP jobs automaticly?

//KK

Highlighted

Re: Poor performance - DFM database server

Hi KK,

        Run this cli and do a count of it, dfpm job list -v jobs-running | wc -l

Regards

adai

Highlighted

Re: Poor performance - DFM database server

I'm having the same issue.  It looks to me like a disk queue issue.  The disk queue length for the disk with the databases frequently goes to 250.  Way, Way, Way too high when it should be 1 or less.

Try the NEW Knowledgebase!
NetApp KB Site
Forums