August 27, 2008 at 2:25 am
Hi All
I’m getting this error on application. The error comes after logging in and trying to select the first available option. (The application is designed in a way that the option needs to be selected else it won’t browse further)
That option is loading data from backend.
I ran a trace but could not make out what is causing it.
What can cause this error and how to overcome it. Can you all please help me.
It’s quite urgent.
Thanks in advance
Thanks
K
August 27, 2008 at 2:35 am
For this kind of error, you should probably contact Microsoft's customer support people. We don't have the tools to read stack dumps and figure out what caused them.
Generally, it's a bug in SQL or in a linked server driver (if you're using those)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 27, 2008 at 4:24 am
hey
I got it resolved by myself.. 🙂
The steps i followed is :
1.Increased the no pf CPU used to all available on server
2. Released the SQL Server to ping for SQL Agent starts
3. Changed the file size spaces allocated to handle the bulk load to 50%
4. Changed the recovery model to simple and then back to full to release log file space
5. Configured SQL Server to use the maximum memory available on server.
I did this in sequence.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply