Help with optimizing DB - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Help with optimizing DB

Author

Topic

mike13
Posting Yak Master

219 Posts

Posted - 2009-10-12 : 18:08:02

Hi all,

I looking for someone that can help me to optimize the Store procedures and view of a Database of an application i wrote.

I got a problem that it is using 100% of CPU all the time, while DB is only link 500mb

I can provide complete DB and profiler log.
Willing to pay some

thanks,

mike

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-10-12 : 19:05:28

Sounds like a missing index or something isn't configured right.

What edition of SQL Server are you using? 64-bit or 32-bit? How much memory does the server have and how much memory is the SQL instance allowed to consume? How many CPUs are there?

Using the query in the below link, are there any "missing" indexes that have an impact of over 1 million?
http://sqlserverpedia.com/wiki/Find_Missing_Indexes

How many data files does tempdb have?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

asgast
Posting Yak Master

149 Posts

Posted - 2009-10-13 : 03:25:08

May be you can give us an example of our code?
Execution plan would be nice, also what kind of hardware are you using?

Can't fall asleep, the ghost of sql server will get me for writing bad queries. Have to stay awake ...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources