求救，sql server高手快来救我！！！

alexyen

My server configuration   Dell R715,  duel AMD Processor opteron 6238 2.60Ghz , RAID 5 (PERC H700) raid controller, configured hard disk size 600*3 usable size is 1200Gb,  64Gb Ram size. having 4 gigabit Ethernet port.
Installed application: OS windows 2008R2 enterprise edition with sp1 and SQL Server 2008R2 enterprise with sp1.
for execute small SQL queries its takes more then 30 to 45 seconds.

But same application installed HP  DL120 G6 server having Intel Xeon X3430 2.4Ghz processor 8Gb Ram 1*500GB hard disk  having 2Gigabit NIC card.

Installed application: OS windows 2008R2 enterprise edition with sp1 and SQL Server 2008R2 enterprise with sp1.
for execute small SQL queries its takes more then 3 to 5 seconds.

Why?

gkheng2003

1) see execution plan
2) cluster key? index key?
3) deadlock?

YoshiHan

and how big is your database size. There might be missing key which we called heap.

alexyen

my database size 500GB + +, without adding log

flashang

check your task manager / CPU / Ram usage.

you may also do a quick testing by backup -- restore to a new database, shrink new database.

fivefooteleven

if you had large records size, check your table index 1st.

hooi1983

lz 可以善用 Execution Plan 来 execute 你的 query 看哪里出问题

93949697

1 database file 500GB? oh quite huge size ...

yiquan1981

我觉得是你搬DB时没有做reindex，你尝试跑 sp_updatestats 看看有没有改变，如果没有就把你的execution plan 放上来

winmxaa

alexyen 发表于 1-2-2013 08:57 AM
my database size 500GB + +, without adding log

我看过的database size 是250GB 而已。
一个database 可以有很多table, 所以database size 不直接影响你的query.

重要的是，你的table几大。
我试过40 millions的records, 但select 只是300miliseconds.
看你怎样design 你的table.

jb270

the sql  
1 base on your  sql design , volume and calculation
2  base on server performance
please show your sql  and more detail