New to a company to be a DBA in the face of the dilemma

It's me today. I just went to a company to work 3 months, 2 months when I became positive, I in two months to the company's main system performance pressure reduced.

But I was more confused. I found that the server CPU pressure source and database poor design, query performance is low. As the company system is a legacy issue,

There's nothing I can do about it, but I could change it. Company stored procedures and query statements are unified in one format, the parameters of stored procedures are generally more than 10, and then return the default value,

For example:

CREATE proc Test

(

@a1 Int=-1,

@a2 nvarchar (50) = ",

.......

)

In the query statement, you will find all of the following:

Select Col1,col2......,coln from TB1 join TB2 on Tb1.id=tb2.id join ...

Where (@a1 =-1 or [email protected])

and (@a2 = "or Tb1.name in" (SELECT * from Function_split (@a2, ', ')))

......

The result of this writing is that most queries are using parallel queries, and I'm still not enough to limit the parallelism of query and threshold adjustments.

Ask the relevant person to change, also ignore.

When you know the system problem where, also know how to solve, but can not start, really very helpless, confused.