Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-04-04 : 22:47:32
|
hi i have two things to cleared...i have a production server which has sql 2000 run on win2k (name prod)i have a development server which has sql7 run on win98 (name dev)(client server development)system configue..prod: compaq server p3 1.13 mhz, 512 mb ramdev dell pc p4 1.13 mhz 256mb ram..does it any where has a process error...when i run a query on prod it gives 17 sec..but when the same query run on dev take 2minboth are index same.... next the big one...when i run a query i get a error on dev SqlDumpExceptionHandler: Process 7 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.i run ok on prod....help me out....thanks======================================Ask to your self before u ask someone |
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-04 : 23:44:21
|
1)Check the execution plans, what is the difference? Make sure your stats are updated. Make sure dev is using the right indexes.2) Please search on Access Violation. Basically, you need to call MS support, It will be free.-Chad |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-04-05 : 00:06:45
|
thanks i will look into the execution plan and come back======================================Ask to your self before u ask someone |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-04-05 : 01:25:09
|
hi chadmat this the first time i am trying to understand execution plan cannot make out much but what i notice is that the plan in dev and production is diffrent.. so i took a simple query select * from bill_process it has 684344 rows.. my dev took 12:39 and prod took 9:10. so when i run bit complex query the diff is lot... mean time i will bruch up the execution plan.. any tips .... welcome======================================Ask to your self before u ask someone |
|
|
|
|
|