Re: Memory usage\Performance problem

Thank you Robert, these all are things that I'll keep in mind.

One more thing though; why is the sqlservr.exe process consuming 395 mb RAM
when the entire server is idle?
My "cron job" is inserting a few 1000 rows of data at night, but now it is
late morning here in Finland, and the entire machine is more or less idle.
On my other servers, the RAM consumption on idle is about 20-30 mb only.
Anyone got any ideas?

/Magnus





"Robert Klemme" <bob.news@xxxxxxx> wrote in message
news:3ngkc3F1dnm7U1@xxxxxxxxxxxxxxxxx
> Magnus Österberg wrote:
>> I guess my expectations on selecting based on a non-indexed column
>> were somewhat high. When I added an index, my query executes in
>> seconds.
>> One index solved this problem, but my table contains 30-40 similar
>> columns, and I don't think indexing every column is a good idea.
>
> Two things come to mind:
>
> 1. rethink your table design. If these columns are so similar you might
> be better off with a second table which is joined. But that of course
> depends on your data - just an idea.
>
> 2. Create indexes (possibly composite indexes) for most used queries. You
> might even get away with a single (or few) composite index if your queries
> only use a leading portion of this index's fields.
>
>> Isn't there any other ways of speeding up selects? Well, I guess
>> not...
>
> Well, there are tons of other options, like having data files on several
> disks, putting tx log on a separate disk, adding memory, .... It all
> depends. :-)
>
> Kind regards
>
> robert
>


.

Relevant Pages

  • Re: coordinates and equations.
    ... If you've changed your mind on this, ... The interesting point is that we see here a crackpot (Robert Winn) which ... not only he is an obvious joke for anyone knowing a bit of ... This is a kind of mental illness: ...
    (sci.physics.relativity)
  • Re: "put down the book" or "put the book down"?
    ... > thread brings to mind the temperance song with the refrain "Put That ... The tread reminded me of the opening line in one of Robert Heinlein's early ... police officer, suddenly encountering an armed suspect, drawing his own ... off, urging the gunman in an even, measured voice to "Put the gun down." ...
    (alt.usage.english)
  • Re: OT: New puter! Geez... what a PITA
    ... GIGs of RAM? ... I wouldn't mind getting used to the new Win7. ...
    (rec.food.cooking)
  • Re: OT: To Robert Regarding Your Videos.
    ... Robert doesn't think he was appreciated enough. ... than this is a tantrum. ... (The exception is the collaboration with me and Dave, ... probably some others that don't come to mind right now) through the mud. ...
    (rec.music.beatles)
  • Re: OT Kerry was right
    ... thing on my mind is to be associated with you or the likes of you in any way ... As for RAM. ... response to your posts to me. ... Now that we have the priorities straight.......YOU initiate a post to ...
    (rec.aviation.military)