Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.sqlserver.programming > #31293
| Path | csiph.com!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!border2.nntp.dca1.giganews.com!Xl.tags.giganews.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!local2.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail |
|---|---|
| NNTP-Posting-Date | Sat, 05 Mar 2016 18:52:57 -0600 |
| From | "Jeff Thompson" <jthompson42@gmail.com> |
| Newsgroups | microsoft.public.sqlserver.programming |
| Subject | Sql Server is Slow - No idea what we are doing |
| References | |
| User-Agent | Mimo Usenet Browser - http://www.mimousenet.com/mimo/post |
| Organization | |
| Message-ID | <-8adnZgU--_34kbLnZ2dnUU7-fednZ2d@giganews.com> (permalink) |
| Date | Sat, 05 Mar 2016 18:52:58 -0600 |
| Lines | 11 |
| X-Usenet-Provider | http://www.giganews.com |
| X-Trace | sv3-prnf1P5LEyHXC8vu44dI33DH+3OwzREoq+f9YLcAD8AogQQwOyCH0NnEETWuVfH+jOCqLJWgugJ4E9h!heUWJeQk7AQ7HeujzGxVhBNkfjKZpFWVqSJZnPZidPGkw4xKplLYQM7vrQKh1Z1pm8zU0E9Fmrn0 |
| X-Complaints-To | abuse@giganews.com |
| X-DMCA-Notifications | http://www.giganews.com/info/dmca.html |
| X-Abuse-and-DMCA-Info | Please be sure to forward a copy of ALL headers |
| X-Abuse-and-DMCA-Info | Otherwise we will be unable to process your complaint properly |
| X-Postfilter | 1.3.40 |
| X-Original-Bytes | 1617 |
| Xref | csiph.com microsoft.public.sqlserver.programming:31293 |
Show key headers only | View raw
Our SQL Server runs slow. Being small we don't have an SQL Admin, requiring us application dev's to figure stuff out. One query we have takes 22 seconds to return 1700 queries. The query is as optimized as we can get it. The server on the other hand needs some love. We don't utilize indexes and have never used profiler or any analysis tools before. I'm looking for a simple tutorial on "When your server is slow.... do these steps" kind of thing. Anyone have any thoughts or resources to get me started on the road to optimizaion? -- Posted by Mimo Usenet Browser v0.2.5 http://www.mimousenet.com/mimo/post
Back to microsoft.public.sqlserver.programming | Previous | Next — Next in thread | Find similar
Sql Server is Slow - No idea what we are doing "Jeff Thompson" <jthompson42@gmail.com> - 2016-03-05 18:52 -0600 Re: Sql Server is Slow - No idea what we are doing Erland Sommarskog <esquel@sommarskog.se> - 2016-03-06 11:13 +0100
csiph-web