Benultra
Posts: 17
|
| Posted: 01/17/2005, 5:35 PM |
|
I have upsized my Access Database to SQL Server 2000, and I am experiencing a slow down. I have check indexs and I have Used Index tuning wizard, but with no improvement.
My initial thoughts is that it takes longer to connect to a SQL Server than and Access Database. I do quiet a few connections in a page, thus the slow down
Has anyone experienced the same problem(s)?
Anyone got any suggestions other that indexs which I have already done (Viewed the Queries in Query Analyzer for Bottlenecks via execution plan!).
Help
Ben
|
 |
 |
GeorgeS
Posts: 206
|
| Posted: 01/20/2005, 12:56 PM |
|
I'd try to see what's going through SQL Server's PROFILER (should be in your SQL Server tools menu).
_________________
GeorgeS |
|
|
|
|
