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.
| Author |
Topic |
|
asuni
Yak Posting Veteran
55 Posts |
 Posted - 2010-04-21 : 03:15:56
|
| Hi All,How to increase database performance, i mean speed of the database.I created indexes also.even though the table select, insert queries are slow. Recently i converted my database from SQLBase to SQLServer 2005.what to do? thanks Suni |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-21 : 04:29:07
|
| That's a very, very vague question. There's no silver bullet for performance. You need to find the queries that are slow and optimise them. These may help you get started.[url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]--Gail ShawSQL Server MVP |
 |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2010-04-21 : 10:19:51
|
quote:
Originally posted by asuni
insert queries are slow
Insert Statements are slow?Insert Statements may be slow?Try Profiler for timing queries?Try Execution Plans to identify possible bottlenecks? |
|
|
|
|
|
|
Database performance