Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 BugCheck Dump........Stack Dump
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

khalik
Constraint Violating Yak Guru

United Arab Emirates
443 Posts

Posted - 04/04/2002 :  22:47:32  Show Profile  Reply with Quote

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 ram
dev
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 2min
both 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

USA
1974 Posts

Posted - 04/04/2002 :  23:44:21  Show Profile  Visit chadmat's Homepage  Reply with Quote
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

Go to Top of Page

khalik
Constraint Violating Yak Guru

United Arab Emirates
443 Posts

Posted - 04/05/2002 :  00:06:45  Show Profile  Reply with Quote

thanks

i will look into the execution plan and come back


======================================
Ask to your self before u ask someone
Go to Top of Page

khalik
Constraint Violating Yak Guru

United Arab Emirates
443 Posts

Posted - 04/05/2002 :  01:25:09  Show Profile  Reply with Quote


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
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000