Solved

Speed up - Microsoft SQL database

Posted on 2010-09-01
6
471 Views
Last Modified: 2012-05-10
Hello

I have a database width 145 million posts in a database, when i do a request it take about a minute and 20 sec, that is LONT TIME !!!

Whau do i speed up my database ?

0
Comment
Question by:radut
6 Comments
 
LVL 9

Expert Comment

by:shalabhsharma
ID: 33578942
0
 

Author Comment

by:radut
ID: 33579104
All that i know ..
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 33579187
What does your request look like?  
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:radut
ID: 33581041
SELECT [Domain]   FROM [tbl_attributes] where Attribute ='meta' and AttributeValue ='Title'
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 33601832
Post your CREATE TABLE SQL statement and the CREATE INDEX for all the indexes.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34114013
I suspect you inadvertently selected my comment as a solution in error.  Please post a message in CS to have this changed.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
What should be a storage size for SQL in day1, day2 and day 3 7 91
Trying to identify overlapping date ranges 5 20
Addition to SQL for dynamic fields 6 37
Query Syntax 17 32
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question