The Daily Static
  The Daily Static
UF Archives
Register
UF Membership
Ad Free Site
Postcards
Community
Geekfinder
UFie Gear
Advertise on UF
Forum Rules
& FAQ

Username

Password


Create a New Account

  
 

Back to UserFriendly Strip Comments Index
Egads I hate MS SQL servers by Kickstart 2004-02-10 17:09:18
Here's the situation...I've got a NT6.0 box running MS SQL and NetTracker. NetTracker has 33 reports, of which 3 or so are EXTREMELY LARGE. While most of the reports take approximately 10 minutes per day to complete, these ones can easily take 6 hours each.

I know there are maintenance tasks and things that can be run to improve MS SQL performance. I know about db_check, and I run it about once per month. Dunno if it helps. For NetTracker I "remove the data" from old months on the large reports and that helps a lot.

Is there anything else I can do? Not only do I hate MS SQL, but I don't know all that much about regularly maintaining it and so I don't want to spend 8 hours (that I really don't have anyway) learning what I can do.

Suggestions?

Thanks,

KS
[ Reply ]
  Indices, maybe? by tnglives2004-02-10 18:48:15
  Index Tuning Wizard by Hulk2004-02-10 22:21:44
    Hi some thoughts by jedidiahstott2004-02-11 00:54:11

 

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)