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 |
ett9300
Starting Member
12 Posts |
Posted - 2011-03-30 : 23:43:05
|
We are running SQL 2000. My .LDF file is 1MB. Is it a concern? The .MDF file is 982 KB. The search is timed out sometimes when users are doing a search.Please let me know if you need additional information.Thanks.Diane |
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-03-31 : 03:23:12
|
As you have small amount of data, log file (ldf) file size seams ok. For time out, run following query and check query time out value for your server.SELECT * FROM sys.configurations WHERE name ='remote query timeout (s)'600 (seconds) is defult value.--------------------------http://connectsql.blogspot.com/ |
 |
|
ett9300
Starting Member
12 Posts |
Posted - 2011-03-31 : 11:52:25
|
Thanks for your prompt response.I don't know where to look for the "remote query timeout(s)". The backend is running SQL 2000. The software is vendor software. The timeout setting is setup in the custom software. Right now, it is being setup for 90 seconds. Would you change the time-out setting as the database is getting larger?I have been setting up the database maintenance in SQL Enterprise Manager to run weekly. Let me know if I am setting up the maintenance correctly. Under Optimizations tab, I selected "Reorganize data and index pages - Reoorganize pages with original amount of free space". Under Integrity tab, I selected "Check database integrity - include indexes". Please let me know if I should add or change anything. This is the only database maintenance being setup. Any comments or recommendations are greatly appreciated.Thanks.Diane |
 |
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2011-03-31 : 13:00:29
|
For such a small amount of data optimisations, etc should be of little value.I'd suspect that you have queries performing joins onto multiple tables which are not supported by indices. can you post sample queries and related table DDL (& execution plans)? |
 |
|
ett9300
Starting Member
12 Posts |
Posted - 2011-03-31 : 13:50:19
|
Thanks for your prompt response, Andrew. I believe that you are correct. There are multiple tables (customer, customer codes, work orders, etc.) connected to the Query. I am not able to post the Query since the vendor has setup the GUI and I don't know how to go to the background.I hope that my database system maintenance is setup correctly in SQL Enterprise Manager. Please let me know if you need additional information.Thanks.Diane |
 |
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2011-04-01 : 05:53:10
|
You can use "SQL Profiler" which is part of SQL EM to profile the code that is running...including tracing the physical queries that are being executed. Learning how to use that tool will become one of your job saviours.....after having a robust (and tested) backup/restore policy in place. |
 |
|
ett9300
Starting Member
12 Posts |
Posted - 2011-04-01 : 15:51:32
|
Thanks for your comment. I open EM. Then, I went to Tools, SQL Query Profile. I got the error message "The specified file was not found". Is there another way to open SQL Query Profile? Do you know why I got that error message?Thanks.Diane |
 |
|
|
|
|
|
|