I want to set threshold for MS SQL monitoring attributes. What should be the values..preferably industry standards.
You would need to check with the Target system being monitored vendor for that type of information.
We have Ca UIM only. to monitor MS SQL DB performance. Is there any place where I can learn what are the key metrics which we should monitor with it's threshold value.
This is highly dependent on your business needs and the needs of the individuals or teams who will be performing the monitoring. There is not really a "one size fits all" or even a "best practice" for monitoring in most cases.
There is an excellent reply by Garin Walsh in the following thread which discusses this in some detail:
Tricky question, what do you monitor? Has anyone found a way to answer this?
What it comes down to is that the stakeholders involved who are familiar with and/or responsible for the SQL DB Servers will need to be consulted to determine what information is most valuable to them. This will vary greatly depending on the nature and needs of the business.