Re: ms sql server grabbing 5Gb. Is this good nomal?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!770.entry



Bookmark it.





The queries to find missing indexes and to find unused(bad) indexes is
invaluable.



You can also look at the Sql Server Dashboard Reports, which puts a nice GUI
onto queries (similar to the ones above).









"Raphael Gomes" <ralgomes@xxxxxxxxx> wrote in message
news:559cfddd-e757-427c-a0fe-7097022c2b9a@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
So I have a .NET site with a few rather large tables (the three main
ones at about 1 million records each). The hosting setup consists of
some Web Servers running IIS 6, being served by another box running MS
SQL Server 2005.

The web servers run smoothly enough, but even without much use (this
site has such a multi-server setup because it has spikes of use near
holidays) but the SQL Server is coughing up and dying about once a
day.

The guys at the hosting company show me the logs showing that the SQL
server is under heavy use (processor at almost +90%, 5Gb of RAM used).

I'm running SQL profiler trying to find out if there are some rogue
query causing trouble (I used linq for this project) but so far, I
haven't seen good benchmarks for sql server performance. Are these
numbers "normal" for a setup like this? (single sql server serving
multiple web servers, tables of about 1 million records each - so far
being used for simple selects, inserts and updates).

Any help would be very much appreciated,

--
Raphael Gomes


.

Relevant Pages

  • Importance of Max Degree of Parallelism in SQL Server
    ... This setting can be changed at the server level by setting the value to 1, which will prevent parallel execution of all queries fired. ... thejami wrote: ... We have four processors on our SQL Server and want to turn on all four now ... parallelism" configuration option. ...
    (microsoft.public.sqlserver.server)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... Access ships with MSDE.. ... >SQL Server Books Online (again-- Access ships with freeware SQL Server ... better ways to achieve their results through queries. ...
    (microsoft.public.excel)
  • Re: Official Status of SQLServer 2005 ADP
    ... solution might be to use ADP. ... With MDB and Linked tables, the only ways of accelerating things are the use ... of Views and the cumbersome use of SQL passthrough queries. ... > SQL Server, and carry on using Access like I aways had. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Sql server as back end
    ... There is an option in the Tools menu, Database Utilities, for Upsize to SQL Server. ... But after that, the queries should generally work, shouldn't they? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL Server 2000 and Latching problem
    ... While the way we indexed our tables and the way we wrote the queries etc ... "chances are you are getting latches because you are ... query on the results the query .. ... SQL Server 2000 and Latching problem ...
    (microsoft.public.sqlserver.connect)