In my experience, the network low on my list of things to review for slow running queries.
returning trivial information, like SELECT @@VERSION should come back instantly. that would quickly show network performance as a baseline, vs other queries that run slower.
much more likely, you want to look at the top slowest performing queries, missing indexes, etc as your first review for performance.
Glenn Berry's website[/url] has some nice scripts to use as a jumping off point.
i'd also get Brent Ozar's SQL Blitz[/url] scripts to review the easy, low hanging fruit if you've been droppe dintot eh accidental DBA role.
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!