100% CPU Usage on a tuned database is nothing to worry about. It just means you are using all available CPU to get your work done.

That being said, there are very few cases where all the SQL on an instance is tuned. My guess is you have some bad queries sucking a lot of CPU that need to be tuned or you have a really large user population. I would look at your run queue to determine if there are jobs waiting.