Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange behaviour
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Strange behaviour
Divers
Thread ID:
00870368
Message ID:
00870368
Vues:
47
Hi Guys,

I am having a very strange problem. When I run a query in enterprise manager(server machine,open table, return all rows, click on sql button and type the query there) it runs super fast. When i run the same query in the query analyzer on the server machine it hangs. This also happens If i run this query from a VFp Client or .net. it just hangs. can someone help me.

The Sql server is running on Windows 2003, 1 gb mem, 300 gb hdd.
The LDF file is 110 GB
the MDF File is 17 GB. No backup of the transaction log has ever been run. The IT Manager only let me know this 1 day ago.

TIA.
Fred Besterwitch, MCP

The harder you work. The luckier you get.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform