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 |
|
sohel
Starting Member
1 Post |
 Posted - 2007-09-17 : 10:10:32
|
| My data files are 6GB, from some days I am facing problem User cannot use properly database because its are very very slow, please helpMy server is DELL PowerEdge-4600 RAM 6GB |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-09-17 : 10:58:35
|
| Far too little information.....you will need to post sample queries, sample DDL and sample execution plans....see the FAQ list...especially Kristens verion in the "New to SQL Server" forum.Speed is the result of "Equipment, database design, query structure, user load and network traffic". You've only "partially" described 1 factor. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-17 : 11:36:14
|
| Are you doing proper housekeeping? reindexing, updating statistics, backup up TLogs, etc?Kristen |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-18 : 23:34:25
|
| What's sql edition? How much memory used by sql? What kind of disk arrays does the server have? How do you place db files on disk? |
|
|
|
|
|
|
Database slow,