Re: Slow SQL-server

"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> skrev i meddelelsen news:7A77127D-7AB6-471B-BA2F-AA5049134E78@xxxxxxxxxxxxxxxx
What settings? There are a huge amount of settings, ranging from the instance level, through the database, table and index level (etc). You can read up on things like sp_configure, sys.databases, sp_indexoption, sp_tableoption, sp_procoption etc. But it is easier to tell you anything concrete if we know what settings you are looking for.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

Some settings witch - by changing them - maybe can give me a better performance !

I have tried to index the fields I use in my "WHERE xxxx" (xxxx - field is now indexed) no impact on the performance at all !

Often it's only one field in the "WHERE" - a boolean - to show if the record is active or not !
My former college implemented this very simple (=stupid) way to "delete" records and I'm now working on getting all in-active records in fact deleted and then delete the "WHERE active=1" in nearly all my stored procedures - will this give some more performance ?

I have about 40 tables with from 5 to 4000 records each - and one of them up to 20.000 records.

The structure is well normalized and some relations has "cashade deleting" set.

8-10 users - it should be a "peace of cake" for the SQL-server I think - but it's so slooooooow !

Any ideas what to do ?

Best regards
KSor

.

Relevant Pages

  • Re: Slow SQL-server
    ... in your case there is not just one easy thing to do to gain performance to your database. ... instance level, through the database, table and index level. ... Some settings witch - by changing them - maybe can give me a better performance! ...
    (microsoft.public.sqlserver.clients)
  • Re: Slow SQL-server
    ... There are a huge amount of settings, ranging from the instance level, through the database, table and index level. ...
    (microsoft.public.sqlserver.clients)
  • Re: Slow SQL-server
    ... As Ekrem stated you need to find the actual bottleneck before you can start addressing the issues otherwise you could be putting effort into the wrong places. ... Andrew J. Kelly SQL MVP ... instance level, through the database, table and index level. ... Some settings witch - by changing them - maybe can give me a better performance! ...
    (microsoft.public.sqlserver.clients)
Loading