| Author |
Topic |
|
jooorj
Posting Yak Master
126 Posts |
 Posted - 2011-04-17 : 18:13:56
|
| i had suffer from sql slow,how can i increase sql server speed? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-04-17 : 18:47:28
|
| i have server with i7 inteland database with 5 GB of data when i log into that server i canot move my mouse in the screen.I think there are 30 employeeswhich are log for 7 hour every day.in my database there are a table of 3 GB of data contains jpg,files,word,excel..etc.so how can I increase the efficiency?and how can detect exactly where is the problem occurs.i think I need a third party software to monitor and explore that problem : I/O - transactions deadlocks,cpu usage, time execution.thank you! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-04-17 : 18:51:01
|
| You can use PerfMon, SQL Profiler (or better yet a server side trace, but I don't think you'll be able to do that), sp_who2 (or better yet Adam Machanic's script), missing indexes report (SQL Server Pedia), and various other things.It sounds like you've got a memory and/or CPU problem. PerfMon will tell you what's the problem if you know how to use the tool. This isn't newbie territory though, you're going to need to do some reading first.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-04-17 : 18:52:10
|
| i have 4 gb of ram |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-18 : 01:38:36
|
| Doesn't change Tara's conclusion. 4GB of RAM is low for a server. My new desktop is coming with 12 GB.Could also be poorly written code/poor indexing.[url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]--Gail ShawSQL Server MVP |
|
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-04-20 : 21:15:10
|
| thanks for all, I have to do all thing you mentioned above , |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
advanced sql problem slow