3
votes
0answers
44 views

New SQL Monitor Showing Database Deadlocks, Should I be alarmed?

We recently installed a SQL Monitoring tool that is raising High Alerts for SQL Server Deadlocks on my SDE database at random times during the day. Using the information provided in the Alert I have ...
0
votes
0answers
50 views

Updating a raster dataset stored in SDE, without schema changes

The Short(ish) Version: I have some rasters, that are generated nightly, that I need to insert into an SDE instance (10.0), sitting on top of an Oracle database (11.1.0.7). I have many users who ...
7
votes
3answers
1k views

Python script - how to avoid exclusive schema lock error?

I have a script for updating some features on my database every night (just for copying and replacing some features). This features are "read-only". My problem is that I can't avoid that these ...