dbTalk Databases Forums  

Profiler and Hibernate

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Profiler and Hibernate in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Erik Sampsell
 
Posts: n/a

Default Profiler and Hibernate - 12-18-2008 , 11:12 AM






I've just started at a new company that is using java and hibernate to
access SQL Server. I tried configuring SQL Profiler to show me what sql
calls are being made to the database and I can't see it.

Can anyone give me some direction? I'm not familiar with hibernate at all.


Reply With Quote
  #2  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Profiler and Hibernate - 12-18-2008 , 04:38 PM






Erik Sampsell (erik (AT) fuzeboxinc (DOT) com) writes:
Quote:
I've just started at a new company that is using java and hibernate to
access SQL Server. I tried configuring SQL Profiler to show me what sql
calls are being made to the database and I can't see it.

Can anyone give me some direction? I'm not familiar with hibernate at
all.
I assume you mean nHibernate? No, I don't know anything about it; I've
only heard the name.

But there is no way that nHibernate can call SQL Server without being
captured in a trace, so this is probably something really trivial. Maybe
your filter is poor. Maybe you failed to include both of RPC:Completed and
TSQL:BatchCompleted. (Include Starting as well, in case all batches errors
out.) Maybe you are tracing the wrong server. Maybe the application wasn't
accessing SQL Server while you were tracing.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #3  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Profiler and Hibernate - 12-18-2008 , 04:38 PM



Erik Sampsell (erik (AT) fuzeboxinc (DOT) com) writes:
Quote:
I've just started at a new company that is using java and hibernate to
access SQL Server. I tried configuring SQL Profiler to show me what sql
calls are being made to the database and I can't see it.

Can anyone give me some direction? I'm not familiar with hibernate at
all.
I assume you mean nHibernate? No, I don't know anything about it; I've
only heard the name.

But there is no way that nHibernate can call SQL Server without being
captured in a trace, so this is probably something really trivial. Maybe
your filter is poor. Maybe you failed to include both of RPC:Completed and
TSQL:BatchCompleted. (Include Starting as well, in case all batches errors
out.) Maybe you are tracing the wrong server. Maybe the application wasn't
accessing SQL Server while you were tracing.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #4  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Profiler and Hibernate - 12-18-2008 , 04:38 PM



Erik Sampsell (erik (AT) fuzeboxinc (DOT) com) writes:
Quote:
I've just started at a new company that is using java and hibernate to
access SQL Server. I tried configuring SQL Profiler to show me what sql
calls are being made to the database and I can't see it.

Can anyone give me some direction? I'm not familiar with hibernate at
all.
I assume you mean nHibernate? No, I don't know anything about it; I've
only heard the name.

But there is no way that nHibernate can call SQL Server without being
captured in a trace, so this is probably something really trivial. Maybe
your filter is poor. Maybe you failed to include both of RPC:Completed and
TSQL:BatchCompleted. (Include Starting as well, in case all batches errors
out.) Maybe you are tracing the wrong server. Maybe the application wasn't
accessing SQL Server while you were tracing.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #5  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Profiler and Hibernate - 12-18-2008 , 04:38 PM



Erik Sampsell (erik (AT) fuzeboxinc (DOT) com) writes:
Quote:
I've just started at a new company that is using java and hibernate to
access SQL Server. I tried configuring SQL Profiler to show me what sql
calls are being made to the database and I can't see it.

Can anyone give me some direction? I'm not familiar with hibernate at
all.
I assume you mean nHibernate? No, I don't know anything about it; I've
only heard the name.

But there is no way that nHibernate can call SQL Server without being
captured in a trace, so this is probably something really trivial. Maybe
your filter is poor. Maybe you failed to include both of RPC:Completed and
TSQL:BatchCompleted. (Include Starting as well, in case all batches errors
out.) Maybe you are tracing the wrong server. Maybe the application wasn't
accessing SQL Server while you were tracing.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #6  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Profiler and Hibernate - 12-18-2008 , 04:38 PM



Erik Sampsell (erik (AT) fuzeboxinc (DOT) com) writes:
Quote:
I've just started at a new company that is using java and hibernate to
access SQL Server. I tried configuring SQL Profiler to show me what sql
calls are being made to the database and I can't see it.

Can anyone give me some direction? I'm not familiar with hibernate at
all.
I assume you mean nHibernate? No, I don't know anything about it; I've
only heard the name.

But there is no way that nHibernate can call SQL Server without being
captured in a trace, so this is probably something really trivial. Maybe
your filter is poor. Maybe you failed to include both of RPC:Completed and
TSQL:BatchCompleted. (Include Starting as well, in case all batches errors
out.) Maybe you are tracing the wrong server. Maybe the application wasn't
accessing SQL Server while you were tracing.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #7  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Profiler and Hibernate - 12-18-2008 , 04:38 PM



Erik Sampsell (erik (AT) fuzeboxinc (DOT) com) writes:
Quote:
I've just started at a new company that is using java and hibernate to
access SQL Server. I tried configuring SQL Profiler to show me what sql
calls are being made to the database and I can't see it.

Can anyone give me some direction? I'm not familiar with hibernate at
all.
I assume you mean nHibernate? No, I don't know anything about it; I've
only heard the name.

But there is no way that nHibernate can call SQL Server without being
captured in a trace, so this is probably something really trivial. Maybe
your filter is poor. Maybe you failed to include both of RPC:Completed and
TSQL:BatchCompleted. (Include Starting as well, in case all batches errors
out.) Maybe you are tracing the wrong server. Maybe the application wasn't
accessing SQL Server while you were tracing.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #8  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Profiler and Hibernate - 12-18-2008 , 04:38 PM



Erik Sampsell (erik (AT) fuzeboxinc (DOT) com) writes:
Quote:
I've just started at a new company that is using java and hibernate to
access SQL Server. I tried configuring SQL Profiler to show me what sql
calls are being made to the database and I can't see it.

Can anyone give me some direction? I'm not familiar with hibernate at
all.
I assume you mean nHibernate? No, I don't know anything about it; I've
only heard the name.

But there is no way that nHibernate can call SQL Server without being
captured in a trace, so this is probably something really trivial. Maybe
your filter is poor. Maybe you failed to include both of RPC:Completed and
TSQL:BatchCompleted. (Include Starting as well, in case all batches errors
out.) Maybe you are tracing the wrong server. Maybe the application wasn't
accessing SQL Server while you were tracing.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #9  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Profiler and Hibernate - 12-18-2008 , 04:38 PM



Erik Sampsell (erik (AT) fuzeboxinc (DOT) com) writes:
Quote:
I've just started at a new company that is using java and hibernate to
access SQL Server. I tried configuring SQL Profiler to show me what sql
calls are being made to the database and I can't see it.

Can anyone give me some direction? I'm not familiar with hibernate at
all.
I assume you mean nHibernate? No, I don't know anything about it; I've
only heard the name.

But there is no way that nHibernate can call SQL Server without being
captured in a trace, so this is probably something really trivial. Maybe
your filter is poor. Maybe you failed to include both of RPC:Completed and
TSQL:BatchCompleted. (Include Starting as well, in case all batches errors
out.) Maybe you are tracing the wrong server. Maybe the application wasn't
accessing SQL Server while you were tracing.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #10  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Profiler and Hibernate - 12-18-2008 , 04:38 PM



Erik Sampsell (erik (AT) fuzeboxinc (DOT) com) writes:
Quote:
I've just started at a new company that is using java and hibernate to
access SQL Server. I tried configuring SQL Profiler to show me what sql
calls are being made to the database and I can't see it.

Can anyone give me some direction? I'm not familiar with hibernate at
all.
I assume you mean nHibernate? No, I don't know anything about it; I've
only heard the name.

But there is no way that nHibernate can call SQL Server without being
captured in a trace, so this is probably something really trivial. Maybe
your filter is poor. Maybe you failed to include both of RPC:Completed and
TSQL:BatchCompleted. (Include Starting as well, in case all batches errors
out.) Maybe you are tracing the wrong server. Maybe the application wasn't
accessing SQL Server while you were tracing.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.