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 |
|
indersshekhawat
Starting Member
26 Posts |
 Posted - 2008-03-20 : 03:31:29
|
| i am using sql server 2000 , vb and crystal report 7.0 for my software, my database size is 2GB. my server is win-2000 servermy reports are going very slow and if one use the report other user show time out error help me on this topic |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-20 : 13:27:57
|
| You haven't provided enough information for us to help yet.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
indersshekhawat
Starting Member
26 Posts |
Posted - 2008-03-21 : 00:52:23
|
| please tell me. i will provide you related information |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 01:00:37
|
| Tried run those queries in query analyzer? Did you check execution plan? Are tables fragmented? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-21 : 01:24:46
|
| Post the queries that are timing out. Include the DDL for the tables as well as the indexes. Let us know how many rows are in each of these tables. What is your timeout setting set to?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
indersshekhawat
Starting Member
26 Posts |
Posted - 2008-03-21 : 06:38:24
|
| my database has three main table 1st table with data more then 300000 ( primary key with varchar) 2nd table with data more then 400000 (primayr key on 2 column one is int and second is varchar) 3rd tabe with data more then 500000 (primary key on 3 column date,varchar and int) |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-03-21 : 17:07:15
|
| Tara asked for table schemas, any indexes that are associated with the tables and the queries that you're trying to execute. You're not giving us enough to effectively help you.Terry |
|
|
|
|
|
|
Timeout expire in sql server