How can we run parallel queries in MSSQL type collectors? Putting "option" statement as in below image resulted in error, anyone has any other suggestion?
option (maxdop 0)
are you able to describe the query that you're putting together please?
MAXDOP – Maximum Degree Of Parallelism can be set to restrict query to run on a certain CPU. Are you wanting to limit the number of CPUs used in your query? If so, maybe it needs to be rewritten to be more efficient.
Hi Paul Douglas,
We want to run our query in a parallel mode with as many CPU as possible. This query runs properly on an MSSQL client but not in VIA.
Hello Paul Douglas
Yes execution time takes too long because of very large amount of data.
We were able to paralellize queries for OracleDB systems without any problem. But for SQL server we are getting above error.
Yes, there are nested queries but how does it relate to the problem we described?
Hi Ece, sorry for the delay I was on leave.
Nested queries will take longer to execute, as they need to be completed in the ascending order for the results to be used by the upper queries. It might not be adding a lot to the total, but it's just something to keep in mind.
Can the SQL admin give you any details about CPU usage when the queries are run? It would definitely help to understand how long the query takes to execute and the CPU usage during execution to determine if there is any scope to make it run faster through hardware utilisation.
Retrieving data ...