sql database running slow

Sid_F
Sid_F used Ask the Experts™
on
My sql database is running slow all of a sudden, nothing else running on the server. I used the perfmon counter for sql called "Data file Size" I noticed this counter immediately ran at 100% I opened up a northwinds for the same counter and its down at about 5%.

Whats does this mean! I'm not familair with sql counters
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2014
Commented:
what kind of database?
Tomas Helgi JohannssonDatabase Administrator / Software Engineer
Commented:
              Hi!

If sql queries are running slow then you should run RUNSTATS on the tables that the queries are tied to.
If that doesn't help then run REORG on those tables.
If you then stilll experience slow queries then you will examine your queries and create new indexes on
the tables based on the columns of the queries WHERE clause.

Hope this helps.

Regards,
    Tomas Helgi  
Top Expert 2015
Commented:
You need to limit database's memory usage to fit in available memory. Parameters differ greatly between different DBMs. If you cannot find anything like "maximum memory usage" in guidebooks you have please be so kind to share your database type and version, and your OS type, version, and also approximate total memory and cpu count in your systems.
Knowing that we will be able to ask fro "essential" config files to post for improvement.
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

Author

Commented:
thanks issue closed
Top Expert 2015

Commented:
Can you describe in short words if you applied one of our solutions, so that we do not feel guilty for life for earning points when not helpful?
Top Expert 2015

Commented:
aikimark - worry not... all questions asked if we can presume some specific DB... and gave small pointers where to look for not-so-common databases

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial