TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Wojciech
NA
9
0
Fast SQLServer vs. slow(??) dotNet
Oct 28 2010 10:10 AM
Hi,
I need your help. My problem is (probably) slow dotNet connection to Ms SQL Server.
I have dotNet application working at IIS v.6 and connected to Ms Sql 2005 base. Base contains storage procedure called
WSWyswietlNag.
When I test this procedure in Sql Server Management Studio, procedure works fast.
When I connect to SQL Server from dotNet Application, procedure works very, very slow.
I don't understand this
phenomenon.
Below is table generated from SQL Profiler.
EventClass
ApplicationName
CPU
Duration
Error
UserId
Reads
RowCounts
TextData
Writes
10
.Net SqlClient Data Provider
24329
25624636
0
sa
144935
9
exec WSWyswietlNag @IDNaglowk=0,@Typ=N' ',@Lok=0,@IDKont=0,@IDKateg=0,
@DataRejOd
=
'Sep 15 2010 12:00:00:000AM',@DataRejDo='Oct 6 2010 12:00:00:000AM',@Nazwa=N'BRAK'
0
12
Microsoft SQL Server Management Studio - Query
63
73398
0
sa
16802
11
exec WSWyswietlNag @IDNaglowk=0,@Typ=N' ',@Lok=0,@IDKont=0,@IDKateg=0,
@DataRejOd
=
'Sep 15 2010 12:00:00:000AM',@DataRejDo='Oct 6 2010 12:00:00:000AM',@Nazwa=N'BRAK'
0
Same procedure, same parameters, different aplication only.
Environment: dotNet 3.0, in application to connect I used SqlDataSource.
What you think about this problem, what happened? Where is problem?
Thank you for each advice.
Wojciech
Reply
Answers (
9
)
What is the difference between CLR 2.0 and CLR 4.0 OR What are all the Improvements Done in CLR 4.0 when compared with CLR 2.0 ?
DataGridView RowHeight